topic Re: Sequence number for selected date? in QlikView https://community.qlik.com/t5/QlikView/Sequence-number-for-selected-date/m-p/1255758#M396880 <HTML><HEAD></HEAD><BODY><P>Probably need <EM>peek</EM> and <EM>order by</EM> :</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3292">Counters in the Load</A></P></BODY></HTML> Tue, 13 Dec 2016 21:01:16 GMT Anonymous 2016-12-13T21:01:16Z Sequence number for selected date? https://community.qlik.com/t5/QlikView/Sequence-number-for-selected-date/m-p/1255757#M396879 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please give me solution for this,</P><P></P><P>I need Sequence number based on the category for selected date.</P><P></P><P>For Example,</P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID&nbsp;&nbsp;&nbsp;&nbsp; Category</P><P>1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connect</P><P><SPAN style="font-size: 13.3333px;">1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connect</SPAN></P><P><SPAN style="font-size: 13.3333px;">1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connect</SPAN></P><P><SPAN style="font-size: 13.3333px;">1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Disconnect</SPAN></P><P><SPAN style="font-size: 13.3333px;">1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Disconnect</SPAN></P><P><SPAN style="font-size: 13.3333px;">1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dicconnect</SPAN></P><P><SPAN style="font-size: 13.3333px;">1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; close</SPAN></P><P><SPAN style="font-size: 13.3333px;">1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; close</SPAN></P><P style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connect</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connect</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connect</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Disconnect</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Disconnect</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dicconnect</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; close</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">2/1/2016&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; close</SPAN></P><P></P><P>Thanks,</P><P>Lawrance. A</P></BODY></HTML> Tue, 13 Dec 2016 20:55:59 GMT https://community.qlik.com/t5/QlikView/Sequence-number-for-selected-date/m-p/1255757#M396879 lawrance 2016-12-13T20:55:59Z Re: Sequence number for selected date? https://community.qlik.com/t5/QlikView/Sequence-number-for-selected-date/m-p/1255758#M396880 <HTML><HEAD></HEAD><BODY><P>Probably need <EM>peek</EM> and <EM>order by</EM> :</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3292">Counters in the Load</A></P></BODY></HTML> Tue, 13 Dec 2016 21:01:16 GMT https://community.qlik.com/t5/QlikView/Sequence-number-for-selected-date/m-p/1255758#M396880 Anonymous 2016-12-13T21:01:16Z