Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@qlikuser5000 did you try uncheck below option in Qlik sense table? It should suppress zero value of the measure
Yes the problem is this though
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
@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
The dimension itself is invalid
@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)
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