Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

100% stacked bar chart

Hi everyone,

I'm working on a 100% stacked bar chart.

I found some topics in the community regarding this question:

100% Stacked bar chart in Qlik Sense | Qlik Community

100% Stacked Bar Graph

Keywords : TOTAL, ALL & DISTINCT

Regretfully, it doesn't seem to be working in my specific situation.

So, I already created a measure with this expression:

Count([Order Reference Deliveries])/Count(Total <Month> [Order Reference Deliveries])

And I created a stacked bar chart with these dimensions/measures:

2017-10-19 19_41_27-Customer Dashboard - Delivery performance _ Werkbladen - Qlik Sense.gif

This is the result:

2017-10-19 19_45_54-Customer Dashboard - Delivery performance _ Werkbladen - Qlik Sense.gif

So.... what am I doing wrong?

13 Replies
sunny_talwar

Try this as your color expression

If(Only({$<IsR24M={1}>} DP_Category) = 'Too late', RGB(131,208,245),

If(Only({$<IsR24M={1}>} DP_Category) = 'On time', RGB(0,108,183)))

Anonymous
Not applicable
Author

Works like a charm, thank you very much!

2018-01-03 14_25_24-KPI² v6 - Delivery performance _ Werkbladen - Qlik Sense.gif

Vito
Contributor
Contributor

Hi, I have the same issue but I am not sure how to correct.  The 100% stacked chart is accumulating the months instead of showing individually.

How can I correct this

mahendrankr
Contributor III
Contributor III

hi sunny, i have similar issue.

From the below data table, im trying to make a 100% stacked chart. But the condition is it would be only for the year 2020.

YearMonthProduUnits
2019JanA5
2019FebA10
2019MarA20
2019JanB5
2019FebB14
2019MarB13
2019JanC7
2019FebC8
2019MarC9
2020JanA5
2020FebA10
2020MarA20
2020JanB5
2020FebB14
2020MarB13
2020JanC7
2020FebC8
2020MarC9

 

Im using the below expression: 

(Sum([Sellout Qty])/Sum( Total <Month> [Sellout Qty]))

but am not able to condition it to the year 2020 only .

Pl help.