topic Looping Data to Create Incremental Counts in QlikView https://community.qlik.com/t5/QlikView/Looping-Data-to-Create-Incremental-Counts/m-p/224896#M77258 <HTML><HEAD></HEAD><BODY><P>I have a similar problem as in the following post: <A href="https://community.qlik.com/forums/p/23725/90696.aspx#90696">http://community.qlik.com/forums/p/23725/90696.aspx#90696</A>.</P><P>I have a table like Table1: ID, SCORE, and COUNT. COUNT is a count of students with that score.</P><P>I need to convert the data in Table1 into multiple records like in Table2. Each ID will have its own set of incremental counts (INCR).</P><P>Any assistance in resolving this is appreciated!</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 125pt; border-collapse: collapse;" width="167"><COLGROUP><COL style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;" width="63" /><COL style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53" /><COL style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD height="17" style="width: 47pt; height: 12.75pt; background-color: transparent; border: #e0dfe3;" width="63">Table1:</TD><TD style="width: 40pt; background-color: transparent; border: #e0dfe3;" width="53"></TD><TD style="width: 38pt; background-color: transparent; border: #e0dfe3;" width="51"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="height: 12.75pt; background-color: silver; border: windowtext 0.5pt solid;">ID</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">SCORE</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">COUNT</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #e0dfe3;"></TD><TD style="background-color: transparent; border: #e0dfe3;"></TD><TD style="background-color: transparent; border: #e0dfe3;"></TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #e0dfe3;">Table2:</TD><TD style="background-color: transparent; border: #e0dfe3;"></TD><TD style="background-color: transparent; border: #e0dfe3;"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="height: 12.75pt; background-color: silver; border: windowtext 0.5pt solid;">ID</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">SCORE</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">INCR</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">4</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">4</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Wed, 27 Jan 2010 21:07:53 GMT 2010-01-27T21:07:53Z Looping Data to Create Incremental Counts https://community.qlik.com/t5/QlikView/Looping-Data-to-Create-Incremental-Counts/m-p/224896#M77258 <HTML><HEAD></HEAD><BODY><P>I have a similar problem as in the following post: <A href="https://community.qlik.com/forums/p/23725/90696.aspx#90696">http://community.qlik.com/forums/p/23725/90696.aspx#90696</A>.</P><P>I have a table like Table1: ID, SCORE, and COUNT. COUNT is a count of students with that score.</P><P>I need to convert the data in Table1 into multiple records like in Table2. Each ID will have its own set of incremental counts (INCR).</P><P>Any assistance in resolving this is appreciated!</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 125pt; border-collapse: collapse;" width="167"><COLGROUP><COL style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;" width="63" /><COL style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53" /><COL style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD height="17" style="width: 47pt; height: 12.75pt; background-color: transparent; border: #e0dfe3;" width="63">Table1:</TD><TD style="width: 40pt; background-color: transparent; border: #e0dfe3;" width="53"></TD><TD style="width: 38pt; background-color: transparent; border: #e0dfe3;" width="51"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="height: 12.75pt; background-color: silver; border: windowtext 0.5pt solid;">ID</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">SCORE</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">COUNT</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #e0dfe3;"></TD><TD style="background-color: transparent; border: #e0dfe3;"></TD><TD style="background-color: transparent; border: #e0dfe3;"></TD></TR><TR height="17" style="height: 12.75pt;"><TD height="17" style="height: 12.75pt; background-color: transparent; border: #e0dfe3;">Table2:</TD><TD style="background-color: transparent; border: #e0dfe3;"></TD><TD style="background-color: transparent; border: #e0dfe3;"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl25" height="17" style="height: 12.75pt; background-color: silver; border: windowtext 0.5pt solid;">ID</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">SCORE</TD><TD class="xl25" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: silver;">INCR</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983836</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">4</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD></TR><TR height="17" style="height: 12.75pt;"><TD align="right" class="xl24" height="17" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 12.75pt; background-color: transparent;">10983870</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">3</TD><TD align="right" class="xl24" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">4</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Wed, 27 Jan 2010 21:07:53 GMT https://community.qlik.com/t5/QlikView/Looping-Data-to-Create-Incremental-Counts/m-p/224896#M77258 2010-01-27T21:07:53Z