Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List Box Expression

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

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Joanna,

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

Or

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

View solution in original post

3 Replies
tamilarasu
Champion
Champion

Hi Joanna,

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

Or

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

Not applicable
Author

Thanks so much Tamil appreciate your help 😃

tamilarasu
Champion
Champion

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