Different Selection for comparsion

[beginnertom]

Hi Everyone,

I plot a line chart as shown in the attached excel.

But I would what to know if I want to select company A &B (Group A) and company C&D (Group B) then compared Group A and Group B in the same chart. How?

Group A and Group B maybe vary (like C&F/A&F ...etc)depending on the users' selection.

Finally, the users can select what the groups they want to compare with, and easily click and show the revenue trend.

Hope who familiar with Qlikview can answer this question! Tks!

[sunny_talwar]

May be use http://www.qlikfix.com/2014/08/12/alternate-states/ to do this

[sunny_talwar · Accepted solution]

Also, look here

https://www.resultdata.com/using-multiple-alternate-states-combined-with-set-analysis-to-create-a-co...

[beginnertom]

Thx sunny!