Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauthamchilled
Creator
Creator

Show relevant previous year in listbox

Hi  All,

 

Need a help in creating a list box with relevant values based on the selection in the first listbox

Period
Load * inline
[
HK_2017_Q2
HK_2017_Q4
HK_2018_Q2
SG_2017_Q2
SG_2017_Q4
SG_2018_Q2
UK_2017_Q2
UK_2017_Q4
UK_2018_Q2
];

I want a listbox with Period to show the above data. And I need another listbox with
PreviousPeriod  or other periods which show only period relevant to the current selected country. How can i do that?

Example 1

Period selection:HK_2018_Q2
Previous Period listbox possible selection should be:HK_2017_Q4, HK_2017_Q2
all other fields should be greyed in the listbox as they are not relevant

Labels (1)
4 Replies
gauthamchilled
Creator
Creator
Author

Any help?

nilaksh92
Partner - Contributor III
Partner - Contributor III

Hi,

 

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

Nilaksh Mahajan

 

gauthamchilled
Creator
Creator
Author

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.

gauthamchilled
Creator
Creator
Author

Can anyone have solution please?