Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create stacked bar chart with line ?

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.

Qlik sense.jpg

1 Solution

Accepted Solutions
shivanandk
Partner - Creator II
Partner - Creator II

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   

Capture.PNG

5. In the Appearance  -> Presentation >  Stacked

Capture1.PNG

View solution in original post

11 Replies
Ivan_Bozov
Luminary
Luminary

Hi! This is possible with a combo chart.

vizmind.eu
shivanandk
Partner - Creator II
Partner - Creator II

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   

Capture.PNG

5. In the Appearance  -> Presentation >  Stacked

Capture1.PNG

Anonymous
Not applicable
Author

Thank  you so much for this clear guide. I made it and shared with my colleagues. Have a good day to you !

Anonymous
Not applicable
Author

Thank you. I have made it based on another answer.

Qlik_Sense_Hub
Contributor II
Contributor II

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,

clipboard_image_0.png

mszetyinszki
Contributor II
Contributor II

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:

qlik combo with line.png

 

Just select  the Stacked option in Presentation:

image.png

If you add a line (like a target ) then switch the line to Primary Axes

image.png

 

simonaubert
Partner - Specialist II
Partner - Specialist II

Hello,

You can also vote on 

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Ideas/Combo-Chart-Color-bars-or-lines-with-a-sec...

 

Best regards,

 

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
Anilb1603
Contributor III
Contributor III

Hi, I have a combo chart with two bars (stacked) and two lines and I want the two lines also to be stacked like the bars. Is there any possibility to do that??

Thanks,

Anil

ioannaiogr
Creator II
Creator II

Hi all, is there a way for the line total to not be presented in a label in the chart when you hover over the bars? Because I believe for the user can be confusing!