Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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
Specialist III
Specialist III

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