topic Line Chart, last x month from today with Set Analysis in QlikView

Line Chart, last x month from today with Set Analysis

Mon, 04 May 2009 20:23:03 GMT

Hi,

i have a line chart with 01/2005 - 04/2009 as dimension and I would like to display only the last x month from today e.g 05/2008 - 04/2009).
Can anyone help me how the set analysis statement should look like
or does it make more sense to implement this without set analysis.
Thanks

Line Chart, last x month from today with Set Analysis

sparur — Mon, 04 May 2009 20:29:10 GMT

Hi, Aloah

Look at the my post (and QV doc there :))

http://community.qlik.com/forums/p/16255/63349.aspx#63349

Line Chart, last x month from today with Set Analysis

Mon, 04 May 2009 21:07:53 GMT

Hi,
sorry I'm a newbie. Am I right that your example refers to the selected date. I'm trying to get a line chart that always shows the last x month from today. No matter what's selected.

Line Chart, last x month from today with Set Analysis

sparur — Mon, 04 May 2009 21:24:08 GMT

Try that:

in expression of chart change expression to:

sum({<MonthYear = {"$(='<='&date(monthStart(Today()), 'MMM-YYYY')&'>'&date(addmonths(date(monthStart(Today())), -12), 'MMM-YYYY'))"}>} Amount)

clear all selections and you will get only X month from today. where X=12.

Line Chart, last x month from today with Set Analysis

sparur — Mon, 04 May 2009 21:26:42 GMT

see in my attachment... (sheetname "Prev X month from today()")

Line Chart, last x month from today with Set Analysis

Mon, 04 May 2009 21:40:00 GMT

thanks sparur. Exactly what I was looking for.

Line Chart, last x month from today with Set Analysis

sparur — Tue, 05 May 2009 13:08:23 GMT

I was glad to help