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: 
Mark4
Partner - Contributor II
Partner - Contributor II

Stacked Bar chart with multiple values

I'm trying to make a stacked bar chart.

The way the data is structured: there are 7 Milestones to choose from for each Record, you will have multiple Milestones for each Record. Some could have none, others could have all 7. There are 4 main Milestones that need to be analyzed.

The goal of the stacked bar chart is to show a count of Records that have designated any of the 4 main Milestones on the bottom, and those that have not on the top. 

 

Attached is my standard bar chart, the dimension is:

=if([Milestone] = 'Key Milestone 1', [Milestone],
if([Milestone] = 'Key Milestone 2', [Milestone],
if([Milestone] = 'Key Milestone 3', [Milestone],
if([Milestone] = 'Key Milestone 4', [Milestone]))))

The Measure is:

Count(DISTINCT{$<[Milestone] = {"Key Milestone 1", "Key Milestone 2", "Key Milestone 3", "Key Milestone 4"} >} DISTINCT [Record])

I got the 'yes' portion to work (attached) but am going in circles how to fill in the top part with the nos.  

Some ideas were a simple calculation of the count(distinct() measure minus the total, that didn't work due to multiple selections.

The app is a binary load from a QVD so I am unable to make a new field, so my calculations need to be done in the app.

Any ideas?

Labels (1)
0 Replies