topic Re: Number each Day of Week in QlikView https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394429#M147090 <HTML><HEAD></HEAD><BODY><P>Hmm, maybe like this then:</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">floor((day(MyDate)-1)/7)+1</SPAN></P></BODY></HTML> Fri, 01 Feb 2013 17:49:34 GMT Gysbert_Wassenaar 2013-02-01T17:49:34Z Number each Day of Week https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394426#M147087 <HTML><HEAD></HEAD><BODY><P>I am looking for a way to number each day of the week. For example 01/07/2013 would be labeled 1 since it is the first monday. Also 12/31/2012 would be the 5th friday of december. Any suggestions would be really helpful. Thank you. </P></BODY></HTML> Fri, 01 Feb 2013 17:24:16 GMT https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394426#M147087 tchovanec 2013-02-01T17:24:16Z Re: Number each Day of Week https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394427#M147088 <HTML><HEAD></HEAD><BODY><P>Try floor(day(MyDate)/7)+1</P></BODY></HTML> Fri, 01 Feb 2013 17:30:02 GMT https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394427#M147088 Gysbert_Wassenaar 2013-02-01T17:30:02Z Re: Number each Day of Week https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394428#M147089 <HTML><HEAD></HEAD><BODY><P>This gives me the correct answer of 5 for 12/31/2012, but for 01/07/2013 I am getting 2 where I would like 1 because it is the ist Monday of the month. </P></BODY></HTML> Fri, 01 Feb 2013 17:33:40 GMT https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394428#M147089 tchovanec 2013-02-01T17:33:40Z Re: Number each Day of Week https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394429#M147090 <HTML><HEAD></HEAD><BODY><P>Hmm, maybe like this then:</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">floor((day(MyDate)-1)/7)+1</SPAN></P></BODY></HTML> Fri, 01 Feb 2013 17:49:34 GMT https://community.qlik.com/t5/QlikView/Number-each-Day-of-Week/m-p/394429#M147090 Gysbert_Wassenaar 2013-02-01T17:49:34Z