Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
letileti
Contributor III
Contributor III

How to avoid showing data for lowest element in hierarchy?

Dear forum,

i have a hierarchy dimension ‘Group’ existing out of several levels - lowest level is X

we should show Actuals and Budget Information except for level X where we show Actuals only ( we leave Budget blank or if possible have the measure hidden)

Example:

GROUP           ACT    BUD

Gr 1                    X           X

   Gr 2                 X           X

       Gr 3             X           X

           X                X         Blank/or hiden

Someone who knows how to?

Labels (3)
2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

If there are no budgets linked to the lowest level, then the Budget cell will be null already. If you want to suppress a non-zero value for the 'X', then you could use Dimensionality() to detect the hierarchy level. Something like this for the budget expression:

If (Dimensionality() < 4, Sum(Budget))     

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
letileti
Contributor III
Contributor III
Author

Hi! Thanks for quick reply!

my data comes on X. The groups 1 2 3 are consolidation elements. Will the dimensionality approach work?