Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser5000
Contributor II
Contributor II

Suppress row if sum = 0 with a dimension

I am moving my dashboard from Qlikview to qliksense and am having an issue with a dimension. In my straight table  I have a dimension that is =If(isnull([3]+[35]+[36]+ [37]+[18]+[39]+[40]),0) and I have it checked so that it suppresses null values. The reason I have this is because I have a measure where if the sum of that expression is 0 then I want the row for that column to also be 0. Now when I put this same dimension in qliksense, I get an invalid dimension error. I've also tried using a set expression and it doesn't work =Sum( {$<[3]={0}>} AMOUNT). The want is if the sum of those is 0 then suppress that line but I need it to be a dimension so I can easily suppress when null unless there is a workaround.

Labels (4)
6 Replies
Kushal_Chawda

@qlikuser5000  did you try uncheck below option in Qlik sense table? It should suppress zero value of the measure

Screenshot 2024-10-16 at 16.21.12.png

qlikuser5000
Contributor II
Contributor II
Author

Yes the problem is this though 

qlikuser5000_0-1729092246018.png

If(isnull([3]+[35]+[36]+ [37]+[18]+[39]+[40]),0) - this is exactly what I have for a dimension in qlikview and it works. I then try this in qliksense and this is the error I get @Kushal_Chawda 

Kushal_Chawda

@qlikuser5000  You don't need to use that conditional dimension If Idea is to suppress zero value of the measure. Uncheck of the option suggested in my previous reply should work

qlikuser5000
Contributor II
Contributor II
Author

qlikuser5000_0-1729093730759.png

The dimension itself is invalid

 

Kushal_Chawda

@qlikuser5000  It seems you are using master measure in the dimension which is not allowed without aggr function. Now you can check suppress null value option for this dimension

=aggr(If([3]+[35]+[36]+ [37]+[18]+[39]+[40]=0,null()),Dimension1,Dimension2)

qlikuser5000
Contributor II
Contributor II
Author

So that is a dimension but what are the referenced dim 1 and dim 2? I'm not sure what I'd be referencing there.  @Kushal_Chawda