Select Multiple years with On Open Trigger

Brip51 — Sat, 30 Jan 2021 13:55:45 GMT

Hi,

I have a field with multiple years. I have a On Open trigger that is currently hardcoded with the values (using

(2010|2011|2012|2013|2014|2015|2016|2017|2018|2019|2020) in the search string).

I cannot hardcode the values so I am trying to create a trigger based on the current year that will select ten years back. It seems like it should be easy, but I can’t get it to work.

If I use this

='<=2020' It works fine. Then I try :

='<=Year(Today())'

With that expression no years are selected.

=Year(Today()) works.

So I am guessing my syntax for less than is wrong?? I have tried different syntax, but I am spinning my wheels.

Any help on this would be appreciated.

Thanks,

Brian

Re: Select Multiple years with On Open Trigger

edwin — Wed, 10 Feb 2021 03:16:17 GMT

use something like

='(' & concat(distinct {<YEAR={">=$(=max({1}YEAR)-10)<=$(=max({1}YEAR))"}>}YEAR, '|') & ')'

Re: Select Multiple years with On Open Trigger

MayilVahanan — Wed, 10 Feb 2021 04:16:39 GMT

HI @Brip51

Try like below

topic Re: Select Multiple years with On Open Trigger in QlikView

Select Multiple years with On Open Trigger

Re: Select Multiple years with On Open Trigger

Re: Select Multiple years with On Open Trigger