Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

grang2019
New Contributor

Best practice on measure hierarchy

If we have measures that have hierarchies (such as Sales Expenses + Marketing Expenses = Total Expenses), in order to have drill down, is it necessary to have them as dimension by cross tab? I could create a measure hierarchy just like dimension hierarchy but it appears not available in pie charts etc to be used as a measure?

 

3 Replies
Employee
Employee

Re: Best practice on measure hierarchy

Current version of Qlik Sense does not have this concept (Hierachy measures), could you elaborate a bit more about your requirement?

grang2019
New Contributor

Re: Best practice on measure hierarchy

Hi thanks for the response. As indicated, the idea is to show some visualisation (Bar for example). And the drill down should reflect details.

Let us say the bars are for each month (Jan, Feb, Mar) and show total expenses (which can be a summary measure). If user clicks on, say, May, it should show for that month, Sales Expenses, Marketing expenses etc which are measures. Right now they are columns in the datasource and loaded as is.  (not cross tab to dimension).

 The row or X-axis can be not necessarily month but something else as well (Say, Company or Division etc)

Highlighted
Employee
Employee

Re: Best practice on measure hierarchy

You can write some custom expression, testing and aggregating different values, for example

IF (Count(distinct Month)=1, sum(Expenses)+Sum(Costs),

sum(Expenses)

)

 

So you can show different metrics based in user selections