Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
qlik sense..
Show the last 3 years..
Is it possible?
Yes, using a set analysis expression. Suppose you now use Sum(Amount) as Measure. You can change this measure so it filters the years. Sum({<MyYear={">=$(=Max(MyYear)-2)<=$(=Max(MyYear))"}>}Amount). Replace MyYear with the name of your year dimension.
Hi Lee,
You can also create a calculated dimension like this:
if(year(today()) - 2 <= year(<Date field>),<Date field>)
This will give you the sum(Amount) for the previous 3 years
for example 2015,2014,2013
Hope this helps!
- Sangram Reddy
everybody thankyou