How Qlik Sense displays multiple bar charts and line charts in the same graph

[Gin009]

Hi guys
I received a request to create the graph in the screenshot through the following excel data in Qliksense Nov 2023. I tried using combo chart, but it did not achieve the expected effect. Please help, thank you!

[LorantPataki]

Hi @Gin009 ,

I'm not sure that I understood your Excel correctly in relation to the screenshot... assuming I did, here's my suggestion:

- add the A, B and C value columns as measures represented as bars on the primary axis

- add the percentage columns as measures represented as lines on the secondary axis

- in Appearance - Presentation - set the bars to Stacked (note this will only work after you set them to be on the same axis!)

here's the rough result:

Note: I'm using Qlik Cloud

[mpc]

Hi, 

Like that ?

I've attached my app. 

Regards

[Gin009]

Hi @LorantPataki 

Thanks for the support, it’s exactly what I want.👍

[Gin009]

Hi @mpc 

Thanks for the support, it’s exactly what I want.👍