topic Suppress Zero-values, but display zero in QlikView

Suppress Zero-values, but display zero

Fri, 11 May 2012 08:15:41 GMT

Hi,

In the presentation tab, there's this "suppress Zero-values" option, which when you checked, zero value will not be shown.

But in line chart, how can i have this options checked and yet, it still plot the zero value?

i can't uncheck this option because it will show a lot of unrelevant values.

any tips ?

Tue, 18 Nov 2014 01:15:48 GMT

I'm having this same issue...Is there still no resolution after 2+ years?

Wed, 19 Nov 2014 20:34:50 GMT

Not sure if you still care nicksatch, but I found a solution to my issue, which might help you (and others)

Use an IF statement to tell the expression to display a blank ' ' value is zero and display the count value is not zero:

If (Count ({<[Course Results] = {Completed}= '0', ' ', Count ({<[Course Results]= {Completed}>} [Dept_Group_Name]

Hope this helps