dynamic month

Mon, 28 Jul 2014 17:25:58 GMT

Hey guys, I'd like to add a condition or create a variable that pulls only data from the last 13 months, and the months while be dynamic, always giving me a rolling 13 months of data. So basically take whatever this month is, and give me the last 13 months of data, for which I have data_fields in my data.

Here's my initial thought for how to do this:

AddMonths(MONTH_NUM, -13)

That's definitely not how to do it, and then I read another post in the Qlik Community about a dynamic date, and here's the expression they suggested:

let vFromDate=date(floor(today()-14))

Is this a viable option for me to use, and how would I translate this variable into pulling only 13 months of data?

Thanks!

Re: dynamic month

maxgro — Mon, 28 Jul 2014 19:54:06 GMT

see attachment

topic dynamic month in QlikView

dynamic month

Re: dynamic month