Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Thank you so much for the response,
My requirement is Something related to this, my issue got solved thank you.