Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Brip51
Creator
Creator

Select Multiple years with On Open Trigger

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

2 Replies
edwin
Master
Master

use something like 

 

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

 

MayilVahanan

HI @Brip51 

Try like below

MayilVahanan_0-1612930591732.png

 

Thanks & Regards,
Mayil Vahanan R