Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppress Zero-values, but display zero

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 ?

2 Replies
Not applicable
Author

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

Not applicable
Author

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