Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
JustinDallas
Valued Contributor II

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

Re: Force chart to show where Measure = 0

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

3 Replies

Re: Force chart to show where Measure = 0

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

JustinDallas
Valued Contributor II

Re: Force chart to show where Measure = 0

Sigh...thanks Sunny...

pabloviera
New Contributor III

Re: Force chart to show where Measure = 0

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.