Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change the measure when using drill-down dimension

Hi All,

Is it possible to change the measure automatically when using the drill-down dimension?

Best Regards,

Louis

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Yes - as long as the drill path uses fields, rather than calculated dimensions. Use GetCurrentField('drillGroupName') to get the current level of the drill down. Use this in your expression, like this:

     =if(GetCurrentField('group') = 'Month', <expression for month>, <expression for other>)

         

In QV, the editor falsely flags this as an error -- I am not sure if the QS editor has the same flaw.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Hi Louis

Yes you can change the measure when using drill-down dimension but we have to mention what are he measure to be calculated in expression better use a set analysis for it