Line chart primary and secondary axis

[Anonymous]

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]

Hi Niky,

I have tried to address your issue please find attached,

hope this helps

[Anonymous]

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]

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.