Discussion board where members can get started with QlikView.
Need a help in creating a list box with relevant values based on the selection in the first listbox
PeriodLoad * inline[HK_2017_Q2HK_2017_Q4HK_2018_Q2SG_2017_Q2SG_2017_Q4SG_2018_Q2UK_2017_Q2UK_2017_Q4UK_2018_Q2];
I want a listbox with Period to show the above data. And I need another listbox withPreviousPeriod or other periods which show only period relevant to the current selected country. How can i do that?
Period selection:HK_2018_Q2Previous Period listbox possible selection should be:HK_2017_Q4, HK_2017_Q2all other fields should be greyed in the listbox as they are not relevant
I have implemented a solution for you in attached qvw. This might solve your problem.
Please accept the answer if it helps.
Thanks and Regards
Thanks for the response. But the second listbox not allowing me to select anything.. All i want is to select a value in the first listbox and second listbox to show only the relevant values.