List Box Expression

[#1]

Hello All,

I have a list box properties which is looking for a dimension calendar year, from 2011 to 2020

I want to use field as a expression and use a formula that only shows 3 years prior the current. Does anyone knows which formula can I use?

Thanks

Joanna

[tamilarasu · Accepted solution]

Hi Joanna,

=If(Year <= Year(Today()) and Year >= Year(Today())-3, Year)

Or

=Aggr(Only({<Year={">=$(=Year(Today())-3)<=$(=Year(Today()))"} >}Year),Year)

[#3]

Thanks so much Tamil appreciate your help 😃

[tamilarasu]

Anytime. Kindly close the thread, if your query was answered. Thank you and have a nice day.

Qlik Community Tip: Marking Replies as Correct or Helpful