topic Re: Line chart primary and secondary axis in QlikView

Line chart primary and secondary axis

Anonymous — Sat, 04 Apr 2015 10:58:39 GMT

I have a line chart with 2 dimensions and 1 expression.

Find attached Qvw.

I want to split the primary axis and secondary axis on basis of UoM.

Scenario 1:

The UoM='INR' should be plotted on primary axis when any Descp with UoM as INR is selected and rest should be plotted on secondary axis

Scenario 2: For Instance

If UoM='USD' and UoM<>'INR' then plotted on primary axis and on second UoM selection as 'Euro' should go on secondary axis.

But if UoM='INR' then should go on primary axis and rest should go on secondary axis.

Thank you in advance...

Anonymous — Sat, 04 Apr 2015 11:42:01 GMT

Hi Niky,

I have tried to address your issue please find attached,

hope this helps

Anonymous — Sat, 04 Apr 2015 11:42:55 GMT

I have created 4 different expressions and kept them conditional as per your scenarios and you can change the expressions as per the requirements

Anonymous — Mon, 06 Apr 2015 05:48:02 GMT

Hi Bhagirath,

I have tried this one however this aggregates the Dimension Descp1.. I want to see the Descp1 -> A1, A2... A.. As all separate lines.

Kindly let me know if there is an workaround with it.