topic List Box auto select previous values in QlikView

List Box auto select previous values

Antoine553 — Fri, 15 Nov 2024 23:44:06 GMT

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

Re: List Box auto select previous values

Kushal_Chawda — Tue, 27 Oct 2020 14:53:38 GMT

@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)

Re: List Box auto select previous values

Antoine553 — Tue, 27 Oct 2020 15:53:55 GMT

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.

Re: List Box auto select previous values

Kushal_Chawda — Tue, 27 Oct 2020 15:58:08 GMT

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

Re: List Box auto select previous values

Antoine553 — Wed, 28 Oct 2020 08:09:13 GMT

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