topic Re: Trigger to default Select to default value or previous selection in QlikView

Trigger to default Select to default value or previous selection

nickedw0 — Wed, 25 Nov 2020 16:16:04 GMT

I use the following trigger to set a Year field selection to Variable1 if Year has no prior selection, or to its previous value. This works if only a single year is preselected. But if multiple years are selected, it fails. Any help would be appreciated.

=if(len(getFieldSelections(Year))=0,Year(Variable1),getFieldSelections(Year))

Thanks

Re: Trigger to default Select to default value or previous selection

sunny_talwar — Mon, 19 Jun 2017 16:42:17 GMT

What is Variable1 here?

Re: Trigger to default Select to default value or previous selection

nickedw0 — Tue, 20 Jun 2017 00:34:39 GMT

Variable1 has the current date

Re: Trigger to default Select to default value or previous selection

sunny_talwar — Tue, 20 Jun 2017 00:48:09 GMT

So when multiple years are selected, then which would be the previous year? Lets say you selected 2017 and 2016, previous year will be 2015?

Re: Trigger to default Select to default value or previous selection

woshua5550 — Tue, 20 Jun 2017 01:59:31 GMT

Try this

=if(getselectioncount(Year)=0,Year(Variable1),'|'&concat(Year,',')&'|')

Re: Trigger to default Select to default value or previous selection

woshua5550 — Tue, 20 Jun 2017 02:22:10 GMT

Sorry, ignore above

It would be

=if(getselectedcount(Year)=0,Year(Variable1),'('&concat(Year,'|')&')')

Re: Trigger to default Select to default value or previous selection

nickedw0 — Tue, 20 Jun 2017 02:51:35 GMT

This is close to perfect. I changed to:

=if(getselectedcount(Year)=0,Year(Variable1),'('&concat(Year,'|')&')')

Problem is each iteration adds a set of brackets, like (((2015|2016))) after 3rd time sheet is selected. or ((((((2015|2016)))))) after 6th.

Re: Trigger to default Select to default value or previous selection

nickedw0 — Tue, 20 Jun 2017 02:58:04 GMT

Ok, That was the correct answer. The extra brackets were comming from an exit trigger I forgot to remove.

Re: Trigger to default Select to default value or previous selection

woshua5550 — Tue, 20 Jun 2017 03:15:12 GMT

Ok,you can mark my answer as correct answer if it was helpful, have a good day:)