topic Re: query in QlikView https://community.qlik.com/t5/QlikView/query/m-p/1347838#M414639 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use Autonumber() in script</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> *,<SPAN style="color: #0000ff;">AutoNumber</SPAN>(<SPAN style="color: #800000;">FieldA</SPAN>) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">AutoNr</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> </SPAN><SPAN style="color: #800000;"><SPAN style="font-size: 10pt;">[</SPAN><BR /><SPAN style="font-size: 10pt;"> FieldA,B</SPAN><BR /><SPAN style="font-size: 10pt;"> A,1</SPAN><BR /><SPAN style="font-size: 10pt;"> A,2</SPAN><BR /><SPAN style="font-size: 10pt;"> A,3</SPAN><BR /><SPAN style="font-size: 10pt;"> B,4</SPAN><BR /><SPAN style="font-size: 10pt;"> B,5</SPAN><BR /><SPAN style="font-size: 10pt;"> B,6</SPAN><BR /><SPAN style="font-size: 10pt;"> ]</SPAN></SPAN><SPAN>;</SPAN></P><P></P><P><SPAN><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166431_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN>Regards,</SPAN></P><P><SPAN>Antonio</SPAN></P><P></P><P></P></BODY></HTML> Sat, 10 Jun 2017 18:26:16 GMT antoniotiman 2017-06-10T18:26:16Z query https://community.qlik.com/t5/QlikView/query/m-p/1347836#M414637 <HTML><HEAD></HEAD><BODY><P>i have a requiremnt where i need to assign a numbers to the given field ,but also it shud reset if the field value changes?</P><P></P><P></P><DIV><DIV> </DIV><DIV><SPAN style="color: #000000; font-size: 10pt; font-family: Segoe UI;">by whuch command we can do that?<BR /></SPAN></DIV><DIV><SPAN style="color: #000000; font-size: 10pt; font-family: Segoe UI;"><BR /></SPAN></DIV></DIV><DIV><DIV> </DIV></DIV></BODY></HTML> Sat, 10 Jun 2017 17:55:20 GMT https://community.qlik.com/t5/QlikView/query/m-p/1347836#M414637 Anonymous 2017-06-10T17:55:20Z Re: query https://community.qlik.com/t5/QlikView/query/m-p/1347837#M414638 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Can you please provide some test data, which will help us to understand your requirement.</STRONG></P></BODY></HTML> Sat, 10 Jun 2017 18:14:36 GMT https://community.qlik.com/t5/QlikView/query/m-p/1347837#M414638 VishalWaghole 2017-06-10T18:14:36Z Re: query https://community.qlik.com/t5/QlikView/query/m-p/1347838#M414639 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use Autonumber() in script</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> *,<SPAN style="color: #0000ff;">AutoNumber</SPAN>(<SPAN style="color: #800000;">FieldA</SPAN>) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">AutoNr</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> </SPAN><SPAN style="color: #800000;"><SPAN style="font-size: 10pt;">[</SPAN><BR /><SPAN style="font-size: 10pt;"> FieldA,B</SPAN><BR /><SPAN style="font-size: 10pt;"> A,1</SPAN><BR /><SPAN style="font-size: 10pt;"> A,2</SPAN><BR /><SPAN style="font-size: 10pt;"> A,3</SPAN><BR /><SPAN style="font-size: 10pt;"> B,4</SPAN><BR /><SPAN style="font-size: 10pt;"> B,5</SPAN><BR /><SPAN style="font-size: 10pt;"> B,6</SPAN><BR /><SPAN style="font-size: 10pt;"> ]</SPAN></SPAN><SPAN>;</SPAN></P><P></P><P><SPAN><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166431_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN>Regards,</SPAN></P><P><SPAN>Antonio</SPAN></P><P></P><P></P></BODY></HTML> Sat, 10 Jun 2017 18:26:16 GMT https://community.qlik.com/t5/QlikView/query/m-p/1347838#M414639 antoniotiman 2017-06-10T18:26:16Z Re: query https://community.qlik.com/t5/QlikView/query/m-p/1347839#M414640 <HTML><HEAD></HEAD><BODY><P>or</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> *,<SPAN style="color: #0000ff;">AutoNumber</SPAN>(<SPAN style="color: #0000ff;">RowNo</SPAN>(),<SPAN style="color: #800000;">FieldA</SPAN>) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">AutoNr</SPAN> <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> FieldA,B<BR /> A,1<BR /> A,2<BR /> A,3<BR /> B,4<BR /> B,5<BR /> B,6<BR /> ]</SPAN></SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166432_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Sat, 10 Jun 2017 18:29:51 GMT https://community.qlik.com/t5/QlikView/query/m-p/1347839#M414640 antoniotiman 2017-06-10T18:29:51Z