Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use trigger to select Possible Values.
Document Properties->Triggers->Field Event Triggers->Selct MonthYear field->On Select->Select Possible->Field :Month
Similarly for Year.
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
Use trigger to select Possible Values.
Document Properties->Triggers->Field Event Triggers->Selct MonthYear field->On Select->Select Possible->Field :Month
Similarly for Year.
Yes Qlikview by default give associations you don't have to do logic for this
This is normal, default QV behaviour - assuming the data is loaded with the proper joins and/or associations.
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.