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: 
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

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)