What can we help you with?

Custom dimension labels for drill down dimensions - New for N4Q 1.7

Follow

A popular feature in Qlik Sense is the use of drill down dimensions. Users can set up hierarchies within their dimension (i.e., Region->State->City) and when users select one of those levels of the hierarchy in their chart in view mode, the chart will automatically drill into the next level down. 

Now, in Narratives for Qlik, users can apply custom dimension labels to each level of the hierarchy. The extension will automatically recognize how many levels of your drill down there are and will allow you to set up custom singular and plural dimension labels for each.

Here we have a chart with a drill down dimension for 'Country->Product Category->Product Sub Category->Product'. We will go into our narrative settings.

Screen_Shot_2017-06-07_at_10.48.51_AM.png

Click 'language' to get to the custom dimension labels

Screen_Shot_2017-06-07_at_10.49.13_AM.png

Now, instead of seeing the one set of labels, you can apply a singular and plural label for each level of the drill down.

Screen_Shot_2017-06-07_at_10.49.37_AM.png

In our case, we will have four sets of labels: country/countries, category/categories, subcategory/subcategories and product/products.

Now, we'll start with our bar chart at the 'country' level of the drill down and the narrative will properly refer to those dimensions as country/countries.

Screen_Shot_2017-06-07_at_10.49.47_AM.png

Now, when we click on one of those countries in view mode, the chart will drill into the product categories for that country. The narrative will update to correctly refer to the dimension as category/categories.

Screen_Shot_2017-06-08_at_9.18.26_AM.png

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk