1 Reply Latest reply: Jul 28, 2014 3:54 PM by Massimo Grossi RSS

    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: Dynamic Date


      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?