Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

1 Reply
maxgro
MVP
MVP

see attachment