Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
fiona
Contributor
Contributor

Showing all dimensions even if the measure has Null or 0 values (bar chart)

We would like to show all dimensions for a bar graph even if there is a Null or 0 value for the following stages and projects.

Ideally, we would like to have this as a stacked bar chart, overall per stage.

Stage orders project name
Ideation    
Ideation 0 challenger
Development 18 observer
Testing 6 space station 1
Testing 4 space station 2

 

Total number of bars to be shown = 3 (Ideation, Development, Testing)

Is it somehow possible to display all 3 stages no matter if one stage contains only 0 and null values?

We tried as follows with set expressions: Min({1}[orders])

But as can be seen below, we need the irrelevant data at the bottom of the bars to not show up.

fiona_0-1641290483809.png

 

0 Replies