Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
=If(Year <= Year(Today()) and Year >= Year(Today())-3, Year)
Thanks so much Tamil appreciate your help =)
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