Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

Second axes in line chart

Dear Colleagues, good day!


I have line chart with 2 expr. Is there any way to add second axes for second expr?


Example in attachment.



Many thanks.


1 Solution

Accepted Solutions

Re: Second axes in line chart

You can choose to put the second expression on the secondary axis on the Axes tab. It's a bad idea because you'll create a confusing chart. It's better to use two charts for this. Can you tell which expression belongs on which axis if you only look at the chart?

comm191934.png


talk is cheap, supply exceeds demand
7 Replies

Re: Second axes in line chart

You can choose to put the second expression on the secondary axis on the Axes tab. It's a bad idea because you'll create a confusing chart. It's better to use two charts for this. Can you tell which expression belongs on which axis if you only look at the chart?

comm191934.png


talk is cheap, supply exceeds demand
mark6505
Valued Contributor III

Re: Second axes in line chart

Hi,

I would have to agree with Gysbert, I would approach as two charts.

In the Axes tab highlight the expression > Tick split axes.

Mark

andreyfcdk91
New Contributor III

Re: Second axes in line chart

No, i can't tell at once dependence between expr and axes.

Now i'm trying to show second axes and it's display isn't practical.

Could you advice something for it please?

balrajahlawat
Esteemed Contributor

Re: Second axes in line chart

This is happening becoz of -ve values in expression..

Could you post sample data for same?

balrajahlawat
Esteemed Contributor

Re: Second axes in line chart

will this help you?

see the attachment..

Re: Second axes in line chart

My advice is to use two separate line charts.


talk is cheap, supply exceeds demand
vincent_ardiet
Contributor III

Re: Second axes in line chart

Hi,

Uncheck the "Forced 0" option it will look nicer.

Community Browser