Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Force chart to show where Measure = 0

Hello Folks,

I have a bar chart which works fine, except for when my measure equals zero.  In these cases, the bar chart doesn't show the name of the dimension, but instead throws away the data point altogether.

For instance, I have an OnTime Delivery % measure which looks like so:

1-

count( [Late Delivery])

/

(count({$<[AgeBucketDRP]=>}[Ontime Delivery])+ count({$<[AgeBucketDRP]=>}[Late Delivery]))

This works, until you run into a selection grouping that has 1 delivery that was late (1 - (1 /( 0 + 1)) => 0.  How can I force my chart to show the zero valued measures?

Any help is greatly appreciated.

1 Solution

Accepted Solutions
sunny_talwar

Have you checked 'Include zero values' under Add-Ons -> Data handling?

View solution in original post

4 Replies
sunny_talwar

Have you checked 'Include zero values' under Add-Ons -> Data handling?

JustinDallas
Specialist III
Specialist III
Author

Sigh...thanks Sunny...

pabloviera
Creator
Creator

EDIT: sorry dismiss my message as it's not exactly your case. Regards.

A workaround people usually recommend in cases like this one is adding something like this:

+(0*count({1}[Late Delivery])) 

It should show the dimension even when there are no possible values.

analyticsuser
Contributor III
Contributor III

Hello,

 I'm having trouble to display 0 in the bar chart even when 'Include zero values' is selected in Data Handling property. Please help!