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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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