Line Chart, last x month from today with Set Analysis

[#1]

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

[sparur]

Hi, Aloah

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

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

[#3]

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.

[sparur]

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.

[sparur]

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

[#6]

thanks sparur. Exactly what I was looking for.

[sparur]

I was glad to help