topic Re: calendar weeks in QlikView https://community.qlik.com/t5/QlikView/calendar-weeks/m-p/375940#M140094 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Week(Today())</P><P></P><P>Hope it helps</P></BODY></HTML> Tue, 31 Jul 2012 13:20:08 GMT MayilVahanan 2012-07-31T13:20:08Z calendar weeks https://community.qlik.com/t5/QlikView/calendar-weeks/m-p/375939#M140093 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>is it possible to calculate the current calendar week ?</P><P></P><P>thanks</P><P></P><P></P><P>backgroun:</P><P>I have this formula</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #800000; font-size: 8pt;">KW</SPAN><SPAN style="font-size: 8pt;"> &lt;= 25, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rangesum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[VerfügtMore]</SPAN><SPAN style="font-size: 8pt;">), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Verfügt IST]</SPAN><SPAN style="font-size: 8pt;">)), null()) </SPAN></P><P></P><P></P><P></P><P>but instead of the 25 I want to have the current calendar week </P></BODY></HTML> Tue, 31 Jul 2012 13:17:37 GMT https://community.qlik.com/t5/QlikView/calendar-weeks/m-p/375939#M140093 2012-07-31T13:17:37Z Re: calendar weeks https://community.qlik.com/t5/QlikView/calendar-weeks/m-p/375940#M140094 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Week(Today())</P><P></P><P>Hope it helps</P></BODY></HTML> Tue, 31 Jul 2012 13:20:08 GMT https://community.qlik.com/t5/QlikView/calendar-weeks/m-p/375940#M140094 MayilVahanan 2012-07-31T13:20:08Z Re: calendar weeks https://community.qlik.com/t5/QlikView/calendar-weeks/m-p/375941#M140095 <HTML><HEAD></HEAD><BODY><P>that's it, thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 31 Jul 2012 13:21:46 GMT https://community.qlik.com/t5/QlikView/calendar-weeks/m-p/375941#M140095 2012-07-31T13:21:46Z