topic Straight Table with record counter that resets in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-with-record-counter-that-resets/m-p/1276735#M518442 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a requirement in which the user wants to assign records in a straight table to variable number of individuals assigned by number. For instance, the user wants to assign the records among 5 individuals. This would need to be variable on the front-end where I would have a slider object allowing the user to define the number of individuals. In this example they have selected 5. Can you reset the rowno(total) counter?</P><P></P><TABLE border="1" class="jiveBorder" height="324" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 152px; height: 297px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Assigned Group</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">9</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">11</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 18 Nov 2016 15:01:33 GMT Anonymous 2016-11-18T15:01:33Z Straight Table with record counter that resets https://community.qlik.com/t5/QlikView/Straight-Table-with-record-counter-that-resets/m-p/1276735#M518442 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a requirement in which the user wants to assign records in a straight table to variable number of individuals assigned by number. For instance, the user wants to assign the records among 5 individuals. This would need to be variable on the front-end where I would have a slider object allowing the user to define the number of individuals. In this example they have selected 5. Can you reset the rowno(total) counter?</P><P></P><TABLE border="1" class="jiveBorder" height="324" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 152px; height: 297px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Assigned Group</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>1</P></TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">9</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">11</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 18 Nov 2016 15:01:33 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-record-counter-that-resets/m-p/1276735#M518442 Anonymous 2016-11-18T15:01:33Z Re: Straight Table with record counter that resets https://community.qlik.com/t5/QlikView/Straight-Table-with-record-counter-that-resets/m-p/1276736#M518443 <HTML><HEAD></HEAD><BODY><P>Mod(RowNo(Total)-1,$(vDivider))+1</P></BODY></HTML> Fri, 18 Nov 2016 15:16:57 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-record-counter-that-resets/m-p/1276736#M518443 Gysbert_Wassenaar 2016-11-18T15:16:57Z Re: Straight Table with record counter that resets https://community.qlik.com/t5/QlikView/Straight-Table-with-record-counter-that-resets/m-p/1276737#M518444 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MOD</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;">)-1,</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(Var3)</EM></STRONG><SPAN style="font-size: 8pt;">)+1<BR /> </SPAN></P><P> Thanks Gysbert!</P><P></P></BODY></HTML> Fri, 18 Nov 2016 15:46:06 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-record-counter-that-resets/m-p/1276737#M518444 Anonymous 2016-11-18T15:46:06Z