Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear friends,
Do anyone know how to create a stacked bar chart, with line in Qlik Sense ? Please see attached image which is what I expect. Number of lIne C is sum of A and B.
Thank you.
Accepted Solutions
Combo Chart will support one Dimension and more than one expression.
1. Add one dimension
2. Create measure A Eg: Sum(Sales) - Set as Bars
3. Create measure B Eg: Sum(ShippingCost) - Set as Bars
4. Create measure C: Sum(Sales) + Sum(ShippingCost) - Set as Line
5. In the Appearance -> Presentation > Stacked
Combo Chart will support one Dimension and more than one expression.
1. Add one dimension
2. Create measure A Eg: Sum(Sales) - Set as Bars
3. Create measure B Eg: Sum(ShippingCost) - Set as Bars
4. Create measure C: Sum(Sales) + Sum(ShippingCost) - Set as Line
5. In the Appearance -> Presentation > Stacked
Thank you. I have made it based on another answer.
I am using Qlik Sense Enterprise version and I don't see stacked Bar. I only see side-by-side bar chart, in the Combo chart option. Please suggest how do I create stacked chart with line
Thank you,
I just solved this in the Enterprise edition by using the Qlik Sense Combo Chart. The trick is to cut the individual stack elements (A, B,C) into separate measures using the set analyses (e.g. measure A=sum({$<CATEGORY={'A'}>} Sales), B=sum({$<CATEGORY={'B'}>} Sales)...)
This solution works good if you have reasonable number of categories (A,B,C) that stack up to the total measure (here Sales), or you would build say 4 measures for the biggest categories and the rest would just be as 'Other' (of course the number of stacks depends on you, but you have to build each separately as a measure).
This makes it possible to stack the individual measures (A,B,C..) on top of each other to show as the total (Sales)...
Here is my actual solution in my scenario:
Just select the Stacked option in Presentation:
If you add a line (like a target ) then switch the line to Primary Axes
