qlik sense dimension

[leechanhee]

qlik sense..

Show the last 3 years..

Is it possible?

[Gysbert_Wassenaar]

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.

[reddy-s]

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

[leechanhee]

everybody thankyou