Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Antoine553
Contributor II
Contributor II

List Box auto select previous values

Hello

I have a List box representing the months of the year just as follow :

01    02    03    04    05    06    07    08    09    10    11    12

Is there a way to force the selection to take all the previous months ?

 

For exemple:

If i select 05, my selection would be 01+02+03+04+05

 

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@Antoine553  see the attached. Go to document properties->Triggers->see field event trigger for Month

View solution in original post

4 Replies
Kushal_Chawda

@Antoine553  You can probably do it via field event triggers but not advisable to use this kind of triggers as it's behavior is unknown. So I would suggest to use set analysis expression to represent the values in graphs like below

=sum({<Month = {"<=$(=max(Month))"}>}Value)

Antoine553
Contributor II
Contributor II
Author

Could you show me how to do it with a trigger please. The application only work with two  totally separated sheets to allow someone to retreive some data as EXCEL file so i shouldn't have problems. I'm trying really hard but i'm loosing way too much time on this problem.

Kushal_Chawda

@Antoine553  see the attached. Go to document properties->Triggers->see field event trigger for Month

Antoine553
Contributor II
Contributor II
Author

Thanks a lot. I thought i started to get everything about Qlikview but i guess I still have a lot to learn.