2 Replies Latest reply: Sep 14, 2012 2:39 PM by whiteline _ RSS

    Numbering Months

      Hi,

       

      I am trying to create a table in Qlikview where I need number months starting Jan 2011 until August 2012.

       

      Example:

       

      Jan 2011 = month 1 and Aug 2012 = month 19. I have tried using the built num(month(field)) function and that only returns the months 1-12. Please let me know if anyone has a solution to this simple question.

       

      Thank you,

       

      Saurav