topic Re: Restart autonumber count every....X in QlikView https://community.qlik.com/t5/QlikView/Restart-autonumber-count-every-X/m-p/694487#M670379 <HTML><HEAD></HEAD><BODY><P><STRONG>RESULT</STRONG></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68616_1.png" style="width: auto; height: auto;" /></P><P><STRONG><BR /></STRONG></P><P><STRONG>SCRIPT</STRONG></P><P><SPAN style="font-size: 8pt;">a:</SPAN></P><P><SPAN style="font-size: 8pt;">load User, Date inline [</SPAN></P><P><SPAN style="font-size: 8pt;">User,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Autonumber</SPAN></P><P><SPAN style="font-size: 8pt;">David,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 4</SPAN></P><P><SPAN style="font-size: 8pt;">Simon,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 4</SPAN></P><P><SPAN style="font-size: 8pt;">];</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">b:</SPAN></P><P><SPAN style="font-size: 8pt;">NoConcatenate</SPAN></P><P><SPAN style="font-size: 8pt;">load *,</SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG>if(User&lt;&gt;peek(User) or Date&lt;&gt;Peek(Date), 1, peek(id)+1) as id</STRONG></SPAN></P><P><SPAN style="font-size: 8pt;">Resident a</SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG>order by User, Date</STRONG>;</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">DROP Table a;</SPAN></P></BODY></HTML> Thu, 09 Oct 2014 16:40:18 GMT maxgro 2014-10-09T16:40:18Z Restart autonumber count every....X https://community.qlik.com/t5/QlikView/Restart-autonumber-count-every-X/m-p/694486#M670378 <HTML><HEAD></HEAD><BODY><P>Howdy, </P><P></P><P>I'm building a dashboard to analyze the Sessions_Servername log file.</P><P></P><P>I want to restart my autonumber counter every Day for each user...So each user will have X # of sessions for each day, then it will restart the next day.</P><P></P><P>Sample output:</P><P></P><P>User,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Autonumber(???)</P><P>David,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 1</P><P>David&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 2</P><P><SPAN style="font-size: 13.3333339691162px;">David&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 3</SPAN></P><P>David&nbsp;&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 1</P><P><SPAN style="font-size: 13.3333339691162px;">David&nbsp;&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 13.3333339691162px;">David&nbsp;&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 13.3333339691162px;">David&nbsp;&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 4</SPAN></P><P><SPAN style="font-size: 13.3333339691162px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333339691162px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333339691162px;">Much thanks,</SPAN></P><P><SPAN style="font-size: 13.3333339691162px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333339691162px;">-David<BR /></SPAN></P></BODY></HTML> Thu, 09 Oct 2014 14:51:29 GMT https://community.qlik.com/t5/QlikView/Restart-autonumber-count-every-X/m-p/694486#M670378 2014-10-09T14:51:29Z Re: Restart autonumber count every....X https://community.qlik.com/t5/QlikView/Restart-autonumber-count-every-X/m-p/694487#M670379 <HTML><HEAD></HEAD><BODY><P><STRONG>RESULT</STRONG></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68616_1.png" style="width: auto; height: auto;" /></P><P><STRONG><BR /></STRONG></P><P><STRONG>SCRIPT</STRONG></P><P><SPAN style="font-size: 8pt;">a:</SPAN></P><P><SPAN style="font-size: 8pt;">load User, Date inline [</SPAN></P><P><SPAN style="font-size: 8pt;">User,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Autonumber</SPAN></P><P><SPAN style="font-size: 8pt;">David,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">David ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 4</SPAN></P><P><SPAN style="font-size: 8pt;">Simon,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/1/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 1</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 2</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 3</SPAN></P><P><SPAN style="font-size: 8pt;">Simon ,&nbsp;&nbsp;&nbsp; 1/2/2014,&nbsp; 4</SPAN></P><P><SPAN style="font-size: 8pt;">];</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">b:</SPAN></P><P><SPAN style="font-size: 8pt;">NoConcatenate</SPAN></P><P><SPAN style="font-size: 8pt;">load *,</SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG>if(User&lt;&gt;peek(User) or Date&lt;&gt;Peek(Date), 1, peek(id)+1) as id</STRONG></SPAN></P><P><SPAN style="font-size: 8pt;">Resident a</SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG>order by User, Date</STRONG>;</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">DROP Table a;</SPAN></P></BODY></HTML> Thu, 09 Oct 2014 16:40:18 GMT https://community.qlik.com/t5/QlikView/Restart-autonumber-count-every-X/m-p/694487#M670379 maxgro 2014-10-09T16:40:18Z Re: Restart autonumber count every....X https://community.qlik.com/t5/QlikView/Restart-autonumber-count-every-X/m-p/694488#M670380 <HTML><HEAD></HEAD><BODY><P>Load *,AutoNumber(RecNo(),Date) Inline [</P><P>User,Date</P><P>David,1/1/2014</P><P>David,1/1/2014</P><P>David,1/1/2014</P><P>David,1/2/2014</P><P>David,1/2/2014</P><P>David,1/2/2014</P><P>David,1/2/2014 ];</P></BODY></HTML> Thu, 09 Oct 2014 17:23:08 GMT https://community.qlik.com/t5/QlikView/Restart-autonumber-count-every-X/m-p/694488#M670380 anbu1984 2014-10-09T17:23:08Z