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!
