Skip to main content
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.