topic Re: How to get 2nd week from Calender? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-2nd-week-from-Calender/m-p/472786#M176538 <HTML><HEAD></HEAD><BODY><P>if you are looking for date range from a Date field, you can try the following expression in an expression of list box:</P><P></P><P><SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="font-size: 2;"></SPAN></SPAN></P><P>=</P><SPAN style="color: #0000ff; font-size: 10pt;">If</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">week</SPAN><SPAN style="font-size: 10pt;">(Your</SPAN><SPAN style="color: #800000; font-size: 10pt;">DateField</SPAN><SPAN style="font-size: 10pt;">)=2,YouDate</SPAN><SPAN style="color: #800000; font-size: 10pt;">Date</SPAN><SPAN style="font-size: 10pt;">)&nbsp; </SPAN><P></P></BODY></HTML> Fri, 14 Jun 2013 04:38:54 GMT tresB 2013-06-14T04:38:54Z How to get 2nd week from Calender? https://community.qlik.com/t5/QlikView/How-to-get-2nd-week-from-Calender/m-p/472785#M176537 <HTML><HEAD></HEAD><BODY><P>How to get 2nd week from Calender?</P><P></P><P>I required expression for it.</P></BODY></HTML> Fri, 14 Jun 2013 04:31:02 GMT https://community.qlik.com/t5/QlikView/How-to-get-2nd-week-from-Calender/m-p/472785#M176537 2013-06-14T04:31:02Z Re: How to get 2nd week from Calender? https://community.qlik.com/t5/QlikView/How-to-get-2nd-week-from-Calender/m-p/472786#M176538 <HTML><HEAD></HEAD><BODY><P>if you are looking for date range from a Date field, you can try the following expression in an expression of list box:</P><P></P><P><SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="font-size: 2;"></SPAN></SPAN></P><P>=</P><SPAN style="color: #0000ff; font-size: 10pt;">If</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">week</SPAN><SPAN style="font-size: 10pt;">(Your</SPAN><SPAN style="color: #800000; font-size: 10pt;">DateField</SPAN><SPAN style="font-size: 10pt;">)=2,YouDate</SPAN><SPAN style="color: #800000; font-size: 10pt;">Date</SPAN><SPAN style="font-size: 10pt;">)&nbsp; </SPAN><P></P></BODY></HTML> Fri, 14 Jun 2013 04:38:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-2nd-week-from-Calender/m-p/472786#M176538 tresB 2013-06-14T04:38:54Z Re: How to get 2nd week from Calender? https://community.qlik.com/t5/QlikView/How-to-get-2nd-week-from-Calender/m-p/472787#M176539 <HTML><HEAD></HEAD><BODY><P>try this</P><P><STRONG>if(week(Date(datefield))=2,</STRONG><STRONG>Date(datefield)</STRONG><STRONG>).</STRONG></P><P></P><P></P><P>suppose today date is 14/06/2013 and its week is 24.</P><P><STRONG>if(week(today())=24,week(today())).</STRONG></P><P></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Fri, 14 Jun 2013 05:13:50 GMT https://community.qlik.com/t5/QlikView/How-to-get-2nd-week-from-Calender/m-p/472787#M176539 2013-06-14T05:13:50Z