Line chart with 2 expression display like Comparative Analysis

[khan_imran]

Hello All,

I am having a requirement to show selection of 2 value from one dimension in one line graph like we do in Comparative Analysis. However, in my case it is will in one graph. Attach is the data and application for help.

Example:

I have LOB as selection dimension,date as my chart dimension and sum of GWP will be my expression. I need 3 buttons to be created for this scenario, one would be for X Axis and second will be for Y axis and third would be to clear the selection. When i select Motor from LOB field and then will click on X Axis button, it would freeze the data. After that I will select Health from LOB field, then click on  Y Axis button. This selection will populated the data on the chart.

After following above step, my chart will have 2 data point, one would be for Motor and second would be for Health,

Hope it clarify my requirement.

Regards,

Imran Khan !

[rupamjyotidas]

Use the help of calculated condition make equations for all the LOB's

WildMatch(GetFieldSelections(LOB),'*Health*')>0

Same for all the values in LOB  in Equation. Then you can select the list box to get the required output.

[khan_imran]

Hi Rupam,

I wanted it dinamic. Anyways I have found a solution.

Thanks

Imran Khan

[rupamjyotidas]

Maybe then you can close the discussion

[khan_imran · Accepted solution]

Attaching solution for other community people !