topic Re: Mark week number in QlikView https://community.qlik.com/t5/QlikView/Mark-week-number/m-p/1319972#M835768 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>'Week ' &amp; Ceil(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">timegap</SPAN>/7) as NewField</STRONG></P></BODY></HTML> Tue, 23 May 2017 15:17:54 GMT sunny_talwar 2017-05-23T15:17:54Z Mark week number https://community.qlik.com/t5/QlikView/Mark-week-number/m-p/1319971#M835767 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>This might be rather a simple one but I couldn't get this to work.</P><P></P><P>I have two date fields from two different table and I populated a new field call timegap using the difference of two date fields. Now i want to create a week field which will be based on timegap field. so if the timegap is 1-7 its week 1, 8-14 its week 2 etc upto week 12 .</P><P></P><P>Thank you</P><P>Naveen</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Mark-week-number/m-p/1319971#M835767 2020-11-25T16:16:04Z Re: Mark week number https://community.qlik.com/t5/QlikView/Mark-week-number/m-p/1319972#M835768 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>'Week ' &amp; Ceil(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">timegap</SPAN>/7) as NewField</STRONG></P></BODY></HTML> Tue, 23 May 2017 15:17:54 GMT https://community.qlik.com/t5/QlikView/Mark-week-number/m-p/1319972#M835768 sunny_talwar 2017-05-23T15:17:54Z Re: Mark week number https://community.qlik.com/t5/QlikView/Mark-week-number/m-p/1319973#M835769 <HTML><HEAD></HEAD><BODY><P>That worked. Thanks</P></BODY></HTML> Tue, 23 May 2017 17:24:48 GMT https://community.qlik.com/t5/QlikView/Mark-week-number/m-p/1319973#M835769 2017-05-23T17:24:48Z