topic Week number starting from 1 from a random date in QlikView https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227876#M79964 <HTML><HEAD></HEAD><BODY><P style="margin: 0in 0in 10pt;">Hi All,</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">I have a date field starting from 26-Nov-2009 . . . . etc.</P><P style="margin: 0in 0in 10pt;">I have a list box with field called "Week" but it shows actual week number from 48 49 50. . . etc</P><P style="margin: 0in 0in 10pt;">I want it as 1 2 3 .</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">How would I achieve this. ? Thanks in Advance</P><P style="margin: 0in 0in 10pt;">Ren</P></BODY></HTML> Tue, 05 Oct 2010 10:16:11 GMT renjithpl 2010-10-05T10:16:11Z Week number starting from 1 from a random date https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227876#M79964 <HTML><HEAD></HEAD><BODY><P style="margin: 0in 0in 10pt;">Hi All,</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">I have a date field starting from 26-Nov-2009 . . . . etc.</P><P style="margin: 0in 0in 10pt;">I have a list box with field called "Week" but it shows actual week number from 48 49 50. . . etc</P><P style="margin: 0in 0in 10pt;">I want it as 1 2 3 .</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">How would I achieve this. ? Thanks in Advance</P><P style="margin: 0in 0in 10pt;">Ren</P></BODY></HTML> Tue, 05 Oct 2010 10:16:11 GMT https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227876#M79964 renjithpl 2010-10-05T10:16:11Z Week number starting from 1 from a random date https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227877#M79965 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Assuming your start date is fixed, how about</P><P style="font-weight: bold">=If(Week &gt;=48, Week - 47, Week + 4)</P><P>Jonathan</P></BODY></HTML> Tue, 05 Oct 2010 11:08:40 GMT https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227877#M79965 jonathandienst 2010-10-05T11:08:40Z Week number starting from 1 from a random date https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227878#M79966 <HTML><HEAD></HEAD><BODY><P>hey dienst thanks for the solution.</P><P>your coding works perfectly, but is there any solution, if my date is not fixed.</P><P>Regards</P><P>ren</P><P></P><P></P></BODY></HTML> Tue, 05 Oct 2010 12:07:41 GMT https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227878#M79966 renjithpl 2010-10-05T12:07:41Z Week number starting from 1 from a random date https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227879#M79967 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Sure. If the week numbers are based on a field or variable called baseDate:</P><P><B>=Week</B> <B>- week(baseDate)</B> <B>+ If(Week &gt;= week(baseDate), 1, 52)</B></P><P>(refactored slightly to reduce the calculations, but mathematically the same).</P><P>Jonathan</P><P style="font-weight: bold"><BR /></P></BODY></HTML> Tue, 05 Oct 2010 13:00:08 GMT https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227879#M79967 jonathandienst 2010-10-05T13:00:08Z Week number starting from 1 from a random date https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227880#M79968 <HTML><HEAD></HEAD><BODY><P>yes, when i used a variable it worked.</P><P>Thanks a lot.</P></BODY></HTML> Tue, 05 Oct 2010 13:29:12 GMT https://community.qlik.com/t5/QlikView/Week-number-starting-from-1-from-a-random-date/m-p/227880#M79968 renjithpl 2010-10-05T13:29:12Z