topic Re: qlik sense dimension in Integration, Extension & APIs

qlik sense dimension

leechanhee — Wed, 18 Nov 2015 00:56:55 GMT

qlik sense..

Show the last 3 years..

Is it possible?

Re: qlik sense dimension

Gysbert_Wassenaar — Wed, 18 Nov 2015 09:30:54 GMT

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.

Re: qlik sense dimension

reddy-s — Wed, 18 Nov 2015 17:31:44 GMT

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

Re: qlik sense dimension

leechanhee — Fri, 20 Nov 2015 01:10:03 GMT

everybody thankyou