https://community.qlik.com/t5/QlikView/Generating-Break-Predefined-Numbers-in-Sequence/m-p/1524944#M438327 <P>Mod(RecNo()-1, $(vConNumLimit))+1 as [To Generate]</P> Sat, 29 Dec 2018 11:10:16 GMT Gysbert_Wassenaar 2018-12-29T11:10:16Z https://community.qlik.com/t5/QlikView/Generating-Break-Predefined-Numbers-in-Sequence/m-p/1524943#M438326 <P>Hi Qlikers,</P><P>&nbsp;</P><P>I was trying achieve below, help me out.&nbsp;I want to create this <STRONG>To Generate</STRONG> Column in script with my data column <STRONG>No</STRONG> ,how it can be possible.&nbsp;</P><P>As i am already having limit stored in&nbsp; <STRONG>&nbsp;Let VConNumLimit=5;&nbsp;</STRONG>.</P><TABLE><TBODY><TR><TD>No</TD><TD>To Generate</TD></TR><TR><TD>1</TD><TD>1</TD></TR><TR><TD>1</TD><TD>2</TD></TR><TR><TD>1</TD><TD>3</TD></TR><TR><TD>1</TD><TD>4</TD></TR><TR><TD>1</TD><TD>5</TD></TR><TR><TD>1</TD><TD>1</TD></TR><TR><TD>1</TD><TD>2</TD></TR><TR><TD>2</TD><TD>3</TD></TR><TR><TD>2</TD><TD>4</TD></TR><TR><TD>2</TD><TD>5</TD></TR><TR><TD>2</TD><TD>1</TD></TR><TR><TD>2</TD><TD>2</TD></TR><TR><TD>2</TD><TD>3</TD></TR><TR><TD>2</TD><TD>4</TD></TR><TR><TD>2</TD><TD>5</TD></TR><TR><TD>2</TD><TD>1</TD></TR><TR><TD>1</TD><TD>2</TD></TR><TR><TD>2</TD><TD>3</TD></TR><TR><TD>3</TD><TD>4</TD></TR><TR><TD>1</TD><TD>5</TD></TR><TR><TD>2</TD><TD>1</TD></TR><TR><TD>3</TD><TD>2</TD></TR><TR><TD>1</TD><TD>3</TD></TR><TR><TD>1</TD><TD>4</TD></TR><TR><TD>2</TD><TD>5</TD></TR><TR><TD>2</TD><TD>1</TD></TR><TR><TD>3</TD><TD>2</TD></TR><TR><TD>3</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Pl Help me out, Attached the excel file for ref.</P><P>Thanks in advance,</P><P>Hirish</P> Sat, 16 Nov 2024 21:40:44 GMT https://community.qlik.com/t5/QlikView/Generating-Break-Predefined-Numbers-in-Sequence/m-p/1524943#M438326 HirisH_V7 2024-11-16T21:40:44Z https://community.qlik.com/t5/QlikView/Generating-Break-Predefined-Numbers-in-Sequence/m-p/1524944#M438327 <P>Mod(RecNo()-1, $(vConNumLimit))+1 as [To Generate]</P> Sat, 29 Dec 2018 11:10:16 GMT https://community.qlik.com/t5/QlikView/Generating-Break-Predefined-Numbers-in-Sequence/m-p/1524944#M438327 Gysbert_Wassenaar 2018-12-29T11:10:16Z