Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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