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 drop downs 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.

[chrismarlow]

Hi Geetha,

If I understand what you are looking for I found this here that might be worth a read Show Excluded Values

So in your case the expression =aggr(Only({<Measure_List=E({$} Measure_List)>}Measure_List), Measure_List) might work. Below see how S2 is shown in the second list box when S1 is selected.

If you want  the second list box to be selectable & use that selection in other objects then you would need to use alterntate states (https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Alternate%20States.htm)

Regards,

Chris.

[geetha_n]

Thank you so much for the response,

My requirement is Something related to this, my issue got solved thank you.