topic Second axes in line chart in QlikView

Second axes in line chart

Anonymous — Wed, 18 Nov 2015 12:19:42 GMT

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.

Re: Second axes in line chart

Gysbert_Wassenaar — Wed, 18 Nov 2015 12:31:52 GMT

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?

Re: Second axes in line chart

Mark_Little — Wed, 18 Nov 2015 12:40:21 GMT

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

Re: Second axes in line chart

Anonymous — Wed, 18 Nov 2015 12:50:16 GMT

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?

Re: Second axes in line chart

Anonymous — Wed, 18 Nov 2015 12:53:47 GMT

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

Could you post sample data for same?

Re: Second axes in line chart

Anonymous — Wed, 18 Nov 2015 12:59:09 GMT

will this help you?

see the attachment..

Re: Second axes in line chart

Gysbert_Wassenaar — Wed, 18 Nov 2015 13:02:11 GMT

My advice is to use two separate line charts.

Re: Second axes in line chart

vincent_ardiet — Wed, 18 Nov 2015 13:18:11 GMT

Hi,

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

Re: Second axes in line chart

anna_castan — Tue, 07 May 2019 11:16:29 GMT

Thankss!!! 🙂