https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953289#M78620 <P>Hi All -&nbsp;</P> <P>I have a spreadsheet with more than thousand records. Need to assign one number for every 6 records.</P> <P>For instance:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nihhalmca_0-1657275451835.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83632i4D0867DDB5470770/image-size/medium?v=v2&amp;px=400" role="button" title="nihhalmca_0-1657275451835.png" alt="nihhalmca_0-1657275451835.png" /></span></P> <P>----------</P> <P>----------</P> <P>Thank you.</P> Fri, 08 Jul 2022 10:20:46 GMT nihhalmca 2022-07-08T10:20:46Z https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953289#M78620 <P>Hi All -&nbsp;</P> <P>I have a spreadsheet with more than thousand records. Need to assign one number for every 6 records.</P> <P>For instance:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nihhalmca_0-1657275451835.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/83632i4D0867DDB5470770/image-size/medium?v=v2&amp;px=400" role="button" title="nihhalmca_0-1657275451835.png" alt="nihhalmca_0-1657275451835.png" /></span></P> <P>----------</P> <P>----------</P> <P>Thank you.</P> Fri, 08 Jul 2022 10:20:46 GMT https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953289#M78620 nihhalmca 2022-07-08T10:20:46Z https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953304#M78621 <P>Is you data always a new IDnumber every 6 numbers?</P> <P>&nbsp;</P> Fri, 08 Jul 2022 11:14:47 GMT https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953304#M78621 JHuis 2022-07-08T11:14:47Z https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953420#M78630 <P><FONT face="courier new,courier">LOAD</FONT><BR /><FONT face="courier new,courier">&nbsp; *</FONT><BR /><FONT face="courier new,courier">&nbsp; Div(RecNo()+5, 6) as ID</FONT><BR /><FONT face="courier new,courier">FROM ...</FONT></P> <P>-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></P> Fri, 08 Jul 2022 14:26:29 GMT https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953420#M78630 rwunderlich 2022-07-08T14:26:29Z https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953880#M78670 <P>Thank you.</P> Mon, 11 Jul 2022 09:01:42 GMT https://community.qlik.com/t5/App-Development/Assign-one-number-for-every-6-records/m-p/1953880#M78670 nihhalmca 2022-07-11T09:01:42Z