topic Re: Dynamic Week Numbers in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Week-Numbers/m-p/1373466#M419503 <HTML><HEAD></HEAD><BODY><P>First you need to manipulate code like <A href="https://community.qlik.com/qlik-blogpost/3545">Redefining the Week Numbers</A></P></BODY></HTML> Tue, 17 Oct 2017 07:22:02 GMT Anil_Babu_Samineni 2017-10-17T07:22:02Z Dynamic Week Numbers https://community.qlik.com/t5/QlikView/Dynamic-Week-Numbers/m-p/1373465#M419502 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>we are trying to Achieve Dynamic last 7 week numbers. created this calculation its working </P><P>=aggr(if(rank(ShipWeek)&lt;=7,ShipWeek),ShipWeek) <SPAN style="font-size: 13.3333px;">but problem is&nbsp; when week 52 (2017)and&nbsp; week 1(2018) come. Above calculation fails in this situation 47,48,49,50,51,52,1.&nbsp;&nbsp; shipweek colum is contains week numbers 1 to 52. please help </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Regards </SPAN></P><P><SPAN style="font-size: 13.3333px;">Prasanth</SPAN></P></BODY></HTML> Mon, 16 Oct 2017 10:36:07 GMT https://community.qlik.com/t5/QlikView/Dynamic-Week-Numbers/m-p/1373465#M419502 prasanth_nossam 2017-10-16T10:36:07Z Re: Dynamic Week Numbers https://community.qlik.com/t5/QlikView/Dynamic-Week-Numbers/m-p/1373466#M419503 <HTML><HEAD></HEAD><BODY><P>First you need to manipulate code like <A href="https://community.qlik.com/qlik-blogpost/3545">Redefining the Week Numbers</A></P></BODY></HTML> Tue, 17 Oct 2017 07:22:02 GMT https://community.qlik.com/t5/QlikView/Dynamic-Week-Numbers/m-p/1373466#M419503 Anil_Babu_Samineni 2017-10-17T07:22:02Z Re: Dynamic Week Numbers https://community.qlik.com/t5/QlikView/Dynamic-Week-Numbers/m-p/1373467#M419504 <HTML><HEAD></HEAD><BODY><P>Hi Anil</P><P></P><P>Unfortunately we don' t have Date column.</P><P>We only have Shipweek column contains numbers 1to 52.</P><P>And shipmonth column contains 2017-10,2017-11,2017-12,2018-1. Like this</P></BODY></HTML> Tue, 17 Oct 2017 12:29:43 GMT https://community.qlik.com/t5/QlikView/Dynamic-Week-Numbers/m-p/1373467#M419504 prasanth_nossam 2017-10-17T12:29:43Z