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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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