topic Re: How to create week numbers from dates in QlikView https://community.qlik.com/t5/QlikView/How-to-create-week-numbers-from-dates/m-p/409641#M152337 <HTML><HEAD></HEAD><BODY><P>WeekName(DateField, 0, -1) will give you Year/Week No. The -1 will offset the Monday to Sunday</P><P></P><P>Hope that helps</P></BODY></HTML> Wed, 05 Dec 2012 13:11:39 GMT 2012-12-05T13:11:39Z How to create week numbers from dates https://community.qlik.com/t5/QlikView/How-to-create-week-numbers-from-dates/m-p/409640#M152336 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a file that outputs week numbers and its dates.</P><P></P><P>I can create week number etc from this for one part of the business but I need to use the date field and create other week numbers from the dates.</P><P></P><P>For example, Business A is fine as the information imported to qlikview contains both the week number and dates. (Mon - Sun)</P><P></P><P>Business B - I need to use the date field to create different week number because the week begins on different days (Sun - Sat)</P><P></P><P>Do you know how I can do this?</P><P></P><P>Gregg</P></BODY></HTML> Wed, 05 Dec 2012 12:53:43 GMT https://community.qlik.com/t5/QlikView/How-to-create-week-numbers-from-dates/m-p/409640#M152336 2012-12-05T12:53:43Z Re: How to create week numbers from dates https://community.qlik.com/t5/QlikView/How-to-create-week-numbers-from-dates/m-p/409641#M152337 <HTML><HEAD></HEAD><BODY><P>WeekName(DateField, 0, -1) will give you Year/Week No. The -1 will offset the Monday to Sunday</P><P></P><P>Hope that helps</P></BODY></HTML> Wed, 05 Dec 2012 13:11:39 GMT https://community.qlik.com/t5/QlikView/How-to-create-week-numbers-from-dates/m-p/409641#M152337 2012-12-05T13:11:39Z