Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

New Contributor II

qlik sense dimension

qlik sense..

Show the last 3 years..

Is it possible?

3 Replies

Re: qlik sense dimension

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.

talk is cheap, supply exceeds demand
Honored Contributor II

Re: qlik sense 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

New Contributor II

Re: qlik sense dimension

everybody thankyou

Community Browser