leechanhee
Contributor II
2015-11-17
07:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
qlik sense dimension
qlik sense..
Show the last 3 years..
Is it possible?
557 Views
3 Replies
2015-11-18
04:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
481 Views
reddy-s
Master II
2015-11-18
12:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
481 Views
leechanhee
Contributor II
2015-11-19
08:10 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
everybody thankyou
481 Views