Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

dynamic month

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!

Tags (2)
1 Reply
maxgro
Not applicable

Re: dynamic month

see attachment