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

    dynamic month

    Scott Magouirk

      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?

       

      Thanks!