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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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