Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

liumeng1234
New Contributor II

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
Contributor II

Re: How to create stacked bar chart with line ?

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

4 Replies
Ivan_Bozov
Valued Contributor

Re: How to create stacked bar chart with line ?

Hi! This is possible with a combo chart.

shivanandk
Contributor II

Re: How to create stacked bar chart with line ?

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

liumeng1234
New Contributor II

Re: How to create stacked bar chart with line ?

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

liumeng1234
New Contributor II

Re: How to create stacked bar chart with line ?

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