Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show only non-zero values in QlikView Pivot tables. I used suppress Zero Values but it is not working on QlikView Expression.
Any suggestion on this.
hi,
try with set analysis: sum({$<MyMeasure={">0"}>}MyMeasure)
Bye
Check the presentation tab in properties if the Supress Zero-Value is checked and in Dimensions tab there is also option Suppress When Value Is Null
A quick tip to get faster and rightly directed solution to your query is to - provide a sample app