topic Grouping 2 Week Data into 1 week in QlikView https://community.qlik.com/t5/QlikView/Grouping-2-Week-Data-into-1-week/m-p/569898#M1107640 <HTML><HEAD></HEAD><BODY><P><BR /><SPAN style="color: #000000; font-size: 10pt;">HI,</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">I have a requirement like need to capture data based on 2-week range dimension.</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;">For Eg:</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;">Period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;"><SPAN style="font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">2/15/2014 - 3/1/2014</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;"><SPAN style="font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">3/2/2014 - 3/16/2014</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</SPAN></P><P><SPAN style="font-style: normal; font-family: 'Arial Unicode MS'; color: #000000; font-size: 10pt; font-weight: normal;">3/17/2014 - 3/31/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 </SPAN></P><P><SPAN style="color: black; font-size: 10pt; font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">4/1/2014 - 4/15/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</SPAN></P><P><SPAN style="color: black; font-size: 10pt; font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">4/16/2014 - 4/30/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 10pt;">I am using WeekEnd_date dimension. How to capture 2 weeks data and it should not be rollingsum.</SPAN></P><P> </P><P> </P><P> </P><P> </P></BODY></HTML> Thu, 13 Mar 2014 11:36:17 GMT 2014-03-13T11:36:17Z Grouping 2 Week Data into 1 week https://community.qlik.com/t5/QlikView/Grouping-2-Week-Data-into-1-week/m-p/569898#M1107640 <HTML><HEAD></HEAD><BODY><P><BR /><SPAN style="color: #000000; font-size: 10pt;">HI,</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 10pt;">I have a requirement like need to capture data based on 2-week range dimension.</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;">For Eg:</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;">Period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Data</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;"><SPAN style="font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">2/15/2014 - 3/1/2014</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;"><SPAN style="font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">3/2/2014 - 3/16/2014</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</SPAN></P><P><SPAN style="font-style: normal; font-family: 'Arial Unicode MS'; color: #000000; font-size: 10pt; font-weight: normal;">3/17/2014 - 3/31/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 </SPAN></P><P><SPAN style="color: black; font-size: 10pt; font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">4/1/2014 - 4/15/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</SPAN></P><P><SPAN style="color: black; font-size: 10pt; font-style: normal; font-family: 'Arial Unicode MS'; font-weight: normal;">4/16/2014 - 4/30/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 10pt;">I am using WeekEnd_date dimension. How to capture 2 weeks data and it should not be rollingsum.</SPAN></P><P> </P><P> </P><P> </P><P> </P></BODY></HTML> Thu, 13 Mar 2014 11:36:17 GMT https://community.qlik.com/t5/QlikView/Grouping-2-Week-Data-into-1-week/m-p/569898#M1107640 2014-03-13T11:36:17Z