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: 
vivientexier
Partner - Creator II
Partner - Creator II

Hidden dimension and calculation


Dimension level 2Sum ( A & B )Sum ( C ) /  Sum ( A & B )
AlphaAANull
AlphaBBNull
AlphaNullNullC

Hi,

How can I hide the third line of my table (where dimension level 2 = null) and keep the result of my expression (Sum(C) / (Sum A & B) in the same time ?

I can make all values of the third line equals to null but the line doesn't not disappear.

In table properties, if I chose to not display null values the line disappear but my calculation ( Sum(C) / Sum(A & B) ) as well.

How can I hide the third line and keep my result ?

3 Replies
SunilChauhan
Champion
Champion

supress Dimension level 2

or

if([Dimension level 2]<>'Null',[Dimension level 2])

then supress null

Sunil Chauhan
vivientexier
Partner - Creator II
Partner - Creator II
Author

Thank you for your answer.

However, I can't suppress Dimension level 2 because I still need to see A & B.

The if statment change Sum( C ) to null.

An easy way of doing it would be to create two tables but it would be nice to have only one table.

SunilChauhan
Champion
Champion

can you upload a sample file and out put required.

Sunil Chauhan