Force selection in listbox

[l_denivelle]

Hi

I have 3 listbox :

- Month year

- Month

- Year

I don't know if it's possible but here is what I need.

When I select a field in "Month year", I want the corresponding value in "Month" and "Year" to be selected (as if I click on the good field in "Month" and "Year").

I put an example in attachment.

Thanks.

[qlikmsg4u]

By default if you select MonthYear in list box corresponding Month and Year will be shown in other list boxes..

are you looking for other than this way?

for selection s in other list boxes too then use triggers

[tresesco · Accepted solution]

Use trigger to select Possible Values.

Document Properties->Triggers->Field Event Triggers->Selct MonthYear field->On Select->Select Possible->Field :Month

Similarly for Year.

[#4]

Yes Qlikview by default give associations you don't have to do logic for this 

[jonathandienst]

This is normal, default QV behaviour - assuming the data is loaded with the proper joins and/or associations.

[l_denivelle]

In fact, I need to get the selected value in some variables.

And when I select a "Month year" value, if I write : GetFieldSelections([Month]) it will return nothing.

Or maybe you have a solution because here is my variable :

LET myvariable= 'Count({<[Année Date BAE]={"$'&'(=' &GetFieldSelections([Year]) & ')"}, [Mois Date BAE]={"$'&'(=GetFieldSelections([Month]))"}>} DISTINCT [Code module])';

And I try to just put [Month] or [Year] in my set analysis but it didn't work :

LET myvariable= 'Count({<[Année Date BAE]={"[Year]"}, [Mois Date BAE]={"[Month]"}>} DISTINCT [Code module])';

Maybe there is another solution, if I create a variable "month year" of my specific date (here Date BAE) like :

MonthName([Date BAE])

I'm going to try and let you know if it works.