Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Hi,
Like that ?
I've attached my app.
Regards
Thanks for the support, it’s exactly what I want.👍
Hi @mpc
Thanks for the support, it’s exactly what I want.👍