How can you make multiple selections of the same field without having to load multiple/duplicate tables of the same data?

[Anonymous]

Hi Qlikview Experts,

Need some help. Not sure if possible thru some kind of set analysis. I have a simple table:

Type	Data 1	Data 2
A	100	50
B	50	50
C	20	50
D	10	20
E	40	50

I am trying to create a Qlikview document where the user can select more than 1 Type. There will then be calculations factoring in the Data1 and Data2 values of the selected Types. So for example, user selects Type=A and Type=D. The document should be able to display the Data1 and Data2 values of each. The document should also be able to make separate calculations using the values of Data1 and Data2 for Type=A, and using the values of Data1 and Data2 for Type=D.

So far I cannot think of a way of doing this other than loading duplicate copies of the table and then relabeling the headers accordingly such as this:

Type_a	Data 1_a	Data 2_a
A	100	50
B	50	50
C	20	50
D	10	20
E	40	50

Type_b	Data 1_b	Data 2_b
A	100	50
B	50	50
C	20	50
D	10	20
E	40	50

I am trying to avoid this approach as certainly not practical.

Thanks for all the help. Please see attached document to illustrate.

[settu_periasamy]

May be, you can try with Alternate State.

[qlikviewwizard · Accepted solution]

Hi Mark,

Please check these links. It will you help you. Thank you.

Re: Alternate States

About Alternate state.

[Anonymous]

Thanks! Exactly what I was looking for!