topic Numbering Months in QlikView https://community.qlik.com/t5/QlikView/Numbering-Months/m-p/409613#M1165000 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am trying to create a table in Qlikview where I need number months starting Jan 2011 until August 2012.</P><P></P><P>Example: </P><P></P><P>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. </P><P></P><P>Thank you,</P><P></P><P>Saurav</P></BODY></HTML> Fri, 14 Sep 2012 17:56:15 GMT 2012-09-14T17:56:15Z Numbering Months https://community.qlik.com/t5/QlikView/Numbering-Months/m-p/409613#M1165000 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am trying to create a table in Qlikview where I need number months starting Jan 2011 until August 2012.</P><P></P><P>Example: </P><P></P><P>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. </P><P></P><P>Thank you,</P><P></P><P>Saurav</P></BODY></HTML> Fri, 14 Sep 2012 17:56:15 GMT https://community.qlik.com/t5/QlikView/Numbering-Months/m-p/409613#M1165000 2012-09-14T17:56:15Z Re: Numbering Months https://community.qlik.com/t5/QlikView/Numbering-Months/m-p/409614#M1165001 <HTML><HEAD></HEAD><BODY><P>If the table gets loaded in order (or do an ORDER BY (Date) in your load, then create a field AUTONUMBER(Month,Year) AS MonthYearNumber to get an integer for each month and year combination.</P></BODY></HTML> Fri, 14 Sep 2012 17:58:34 GMT https://community.qlik.com/t5/QlikView/Numbering-Months/m-p/409614#M1165001 Anonymous 2012-09-14T17:58:34Z Re: Numbering Months https://community.qlik.com/t5/QlikView/Numbering-Months/m-p/409615#M1165002 <HTML><HEAD></HEAD><BODY><P>=(year(Date) - year(StartDate))*12 + month(Date) - Month(StartDate) + 1</P><P></P><P>StartDate - Jan 2011 (or you can use min() function)</P><P>Date - your periods.</P></BODY></HTML> Fri, 14 Sep 2012 18:39:57 GMT https://community.qlik.com/t5/QlikView/Numbering-Months/m-p/409615#M1165002 whiteline 2012-09-14T18:39:57Z