topic How to count weeks in a date range? in QlikView https://community.qlik.com/t5/QlikView/How-to-count-weeks-in-a-date-range/m-p/473377#M485644 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>how can I count, in script,&nbsp; weeks in a data range, considering that I can have different years?</P><P>If EndDate and StartDate are weeks, I cannot do something like this because I have different years, so I can have week #3 twice, for 2012 and 2013.</P><P></P><P>Load Distinct</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;weekend('$(EndDate)' - Recno() +1) as DATA_GIACENZA</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AutoGenerate( '$(EndDate)' - '$(StartDate)');</P><P></P><P>How can I do that?<BR />Thanks a lot!</P></BODY></HTML> Mon, 22 Apr 2013 10:22:34 GMT Anonymous 2013-04-22T10:22:34Z How to count weeks in a date range? https://community.qlik.com/t5/QlikView/How-to-count-weeks-in-a-date-range/m-p/473377#M485644 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>how can I count, in script,&nbsp; weeks in a data range, considering that I can have different years?</P><P>If EndDate and StartDate are weeks, I cannot do something like this because I have different years, so I can have week #3 twice, for 2012 and 2013.</P><P></P><P>Load Distinct</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;weekend('$(EndDate)' - Recno() +1) as DATA_GIACENZA</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AutoGenerate( '$(EndDate)' - '$(StartDate)');</P><P></P><P>How can I do that?<BR />Thanks a lot!</P></BODY></HTML> Mon, 22 Apr 2013 10:22:34 GMT https://community.qlik.com/t5/QlikView/How-to-count-weeks-in-a-date-range/m-p/473377#M485644 Anonymous 2013-04-22T10:22:34Z