topic Re: Best practice on measure hierarchy in App Development

Best practice on measure hierarchy

User_2019 — Mon, 07 Jan 2019 08:46:11 GMT

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?

Re: Best practice on measure hierarchy

Clever_Anjos — Mon, 07 Jan 2019 10:49:12 GMT

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

Re: Best practice on measure hierarchy

User_2019 — Mon, 07 Jan 2019 11:44:44 GMT

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)

Re: Best practice on measure hierarchy

Clever_Anjos — Mon, 07 Jan 2019 12:07:39 GMT

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