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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
heathqm
Partner - Contributor III
Partner - Contributor III

Displaying Empty Buckets on the Bar Chart Legend

Is there a way to display all the buckets created on the bar chart? 

Right now I have created buckets like this in the data load editor: 

If([Total Program Status Value] <= 0, '0',
If([Total Program  Status Value] > 0 and [Total Program Status Value] <=3, '1-3',
If([Total Program  Status Value] > 3 and [Total Program Status Value] <=6, '4-6',
If([Total Program Status Value] > 6 and [Total Program  Status Value] <=9, '7-9',
If([Total Program Status Value] > 9, '10+'
))))) AS [Bucket]

 

Then I created a Bar chart with two dimensions Program and Buckets then a measure  of Count(DISTINCT{<[Bucket]>} [Program])

 

Right now, there are currently no 0 buckets the way the data is, so I can't get it to show up on the bar chart.

heathqm_0-1646076042044.png

 

So I tried to put each bucket in as a separate measure like this: Count(DISTINCT{<[Bucket] = {'0'}>} [Program]) but then the buckets are not selectable on the legend and I am only able to select one Program to filter by instead of the buckets.

I had double checked to make sure 'Suppress 0 values' is not checked. 

Any help is appreciated. 

Labels (1)
1 Reply
Digvijay_Singh
MVP
MVP

Not sure of the solution without having access to data and the app but I use sometimes this below trick to show dimensions with 0 metric values - 

Count(DISTINCT{<[Bucket]>} [Program]) + Count({1}0)