I have a field Measure_List, and has to display two drop downs from it

[geetha_n]

Hi, I have a problem in Qlik VIew

I have a field Measure_List, and I want to do two dropdowns from it, Consider S1 and S2.

Once S1 is selected, the selected value should not be there in S2. And I want to display a chart based on the selected values.

Can anyone help on this!

Thanks in advance.

[johanlindell]

Hi,

You have two options, one is to use alternate states and the other is to work with current and previous selections. Both will incorporate set expressions.

If you are not using alternate states make two list boxes. The first one can have a direct link to the Measue_List field. The second will have an expression like this 

Aggr (Only{<Measure_List -= P(Measure_List)>} Measure_List), Measure_List)

Then you can have your chart display the tow different selections:

1. First selection:

Sum ({$1} [Your field])

2. Second selection

Sum ([Your field])