topic Re: Force selection in listbox in QlikView

Force selection in listbox

l_denivelle — Mon, 14 Sep 2015 12:32:31 GMT

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.

Re: Force selection in listbox

qlikmsg4u — Mon, 14 Sep 2015 12:35:24 GMT

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

Re: Force selection in listbox

tresB — Mon, 14 Sep 2015 12:37:29 GMT

Use trigger to select Possible Values.

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

Similarly for Year.

Re: Force selection in listbox

Mon, 14 Sep 2015 12:40:27 GMT

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

Re: Force selection in listbox

jonathandienst — Mon, 14 Sep 2015 12:41:14 GMT

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

Re: Force selection in listbox

l_denivelle — Mon, 14 Sep 2015 12:46:45 GMT

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.