Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.