topic Cummulative week in QlikView https://community.qlik.com/t5/QlikView/Cummulative-week/m-p/219575#M72586 <HTML><HEAD></HEAD><BODY><P>hi Patrick,</P><P>For Sum over a range you can use either above function, if there is no bifurcation required or use mapping tables</P><P>like</P><P>week AsOnWeek</P><P>1 1</P><P>2 1</P><P>2 2</P><P>3 1</P><P>3 2</P><P>3 3</P><P>&amp; use AsOnWeek instead of week</P><P>Thanks</P><P>Amar</P><P></P></BODY></HTML> Mon, 18 Apr 2011 11:43:56 GMT amars 2011-04-18T11:43:56Z Cummulative week https://community.qlik.com/t5/QlikView/Cummulative-week/m-p/219574#M72585 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have question:</P><P>I want to cummulate, in a period of 16 week, 4 week in a row</P><P>For example:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192pt; border-collapse: collapse;" width="256"><COLGROUP><COL span="4" style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD height="17" style="width: 48pt; height: 12.75pt; background-color: transparent; border: #d4d0c8;" width="64">Name</TD><TD style="width: 48pt; background-color: transparent; border: #d4d0c8;" width="64">week</TD><TD style="width: 48pt; background-color: transparent; border: #d4d0c8;" width="64">aantal</TD><TD style="width: 48pt; background-color: transparent; border: #d4d0c8;" width="64">cumm</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">2</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">3</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">4</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">4</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt; background-color: yellow; border: #d4d0c8;">pdr</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">5</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">1</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt; background-color: yellow; border: #d4d0c8;">pdr</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">6</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">10</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">11</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt; background-color: yellow; border: #d4d0c8;">pdr</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">7</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">1</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">12</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt; background-color: yellow; border: #d4d0c8;">pdr</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">8</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">1</TD><TD align="right" class="xl22" style="background-color: yellow; border: #d4d0c8;">13</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl23" height="17" style="height: 12.75pt; background-color: #ccffcc; border: #d4d0c8;">pdr</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">9</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">3</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl23" height="17" style="height: 12.75pt; background-color: #ccffcc; border: #d4d0c8;">pdr</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">10</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">2</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">5</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl23" height="17" style="height: 12.75pt; background-color: #ccffcc; border: #d4d0c8;">pdr</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">11</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">1</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">6</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl23" height="17" style="height: 12.75pt; background-color: #ccffcc; border: #d4d0c8;">pdr</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">12</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">1</TD><TD align="right" class="xl23" style="background-color: #ccffcc; border: #d4d0c8;">7</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">13</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">14</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">15</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #d4d0c8;">pdr</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">16</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">1</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">4</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Can anybody help me?</P><P></P><P></P><P>Patrick</P></BODY></HTML> Mon, 18 Apr 2011 09:38:26 GMT https://community.qlik.com/t5/QlikView/Cummulative-week/m-p/219574#M72585 2011-04-18T09:38:26Z Cummulative week https://community.qlik.com/t5/QlikView/Cummulative-week/m-p/219575#M72586 <HTML><HEAD></HEAD><BODY><P>hi Patrick,</P><P>For Sum over a range you can use either above function, if there is no bifurcation required or use mapping tables</P><P>like</P><P>week AsOnWeek</P><P>1 1</P><P>2 1</P><P>2 2</P><P>3 1</P><P>3 2</P><P>3 3</P><P>&amp; use AsOnWeek instead of week</P><P>Thanks</P><P>Amar</P><P></P></BODY></HTML> Mon, 18 Apr 2011 11:43:56 GMT https://community.qlik.com/t5/QlikView/Cummulative-week/m-p/219575#M72586 amars 2011-04-18T11:43:56Z