topic Re: Line chart with 2 expression display like Comparative Analysis in QlikView

Line chart with 2 expression display like Comparative Analysis

khan_imran — Wed, 25 Nov 2020 16:16:04 GMT

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 !

Re: Line chart with 2 expression display like Comparative Analysis

rupamjyotidas — Wed, 30 Nov 2016 19:40:09 GMT

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.

Re: Line chart with 2 expression display like Comparative Analysis

khan_imran — Thu, 01 Dec 2016 18:32:01 GMT

Hi Rupam,

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

Thanks

Imran Khan

Re: Line chart with 2 expression display like Comparative Analysis

rupamjyotidas — Thu, 01 Dec 2016 18:34:11 GMT

Maybe then you can close the discussion

Re: Line chart with 2 expression display like Comparative Analysis

khan_imran — Sat, 03 Dec 2016 12:19:56 GMT

Attaching solution for other community people !