Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Line Chart with double Y-axes

Hi guys,

I need to produce the following Line Chart.

Capture.PNG

My problem is the following one: I'm able to create it but i don't know how to insert the second Y-axes (with the percentage that is inside of my CrossTable). Anyone have an idea?

Thanks in advance,

Ale

4 Replies
OmarBenSalem

To be able to add 2 Y-axis, you need to use a combined chart; and the seconde measure must be of a different form then the first measure.

exp: firest measures bar, 2nd measure, lines:

Capture.PNG

You can have for example:

dimension:

Month:

Measure 1 :sum(Sales)

measure 2: sum(Sales) / sum(Total Sales) and format it as %:

Capture.PNG

Not applicable
Author

I really thank you for the answer!

The problem is I need two dimensions and two measures in a line chart and, with the combo box, i can add only one dimension.

any ideas?

Thanks in advance,

Ale

Ken_T
Specialist
Specialist

you can do this with a COMBO chart and then change the BAR chart to also be a line chart. Data > Dimensions > Measures > More Properties > Presentation.   (not to be confused with Appearance > Presentation) .  then you will have a chart, with multiple lines and 2 different Y axis. can only have one dimension though in the combo chart

anat
Master
Master

Split Y-axis is currently not supported in Qlik Sense line chart object.

you can use combo chart to display data Y -axis left and right part.