Discussion board where members can get started with QlikView.
I want not to show the empty and zero values from the chart.
I checked suppress zero values and suppress null values. But it is not working. Version is 11.0 SR2 64bit
Please help me.
Go to Solution.
Try this expressions
if(Floor(sum(COMM)) <>0 , sum(COMM))
if(Round(sum(COMM)) <>0 , sum(COMM))
I could not see any null/blank values in your chart.
I don't see it either
Can you post a screenshot of what you are seeing?
Check whether you have floating point numbers like 0.00054. If you have like this Use Floor()/Ceil()/Round().
Note: 0 <> 0.0000345 or any other number.