Best practice on measure hierarchy

[User_2019]

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?

[Clever_Anjos]

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

[User_2019]

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)

[Clever_Anjos]

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