topic How to reset counter at each unique value in script? in QlikView https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361987#M821396 <HTML><HEAD></HEAD><BODY><P>Hypothetical Source Data:</P><P></P><P> Dog</P><P> Dog</P><P> Dog</P><P> Dog</P><P> Cat</P><P> Cat</P><P> Chicken</P><P> Chicken</P><P> Bird</P><P></P><P>Desired Output:</P><P> Dog|1</P><P> Dog|2</P><P> Dog|3</P><P> Dog|4</P><P> Cat|1</P><P> Cat|2</P><P> Cat|3</P><P> Chicken|1</P><P> Chicken|2</P><P> Bird|1</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT devan9876 2020-11-25T16:16:04Z How to reset counter at each unique value in script? https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361987#M821396 <HTML><HEAD></HEAD><BODY><P>Hypothetical Source Data:</P><P></P><P> Dog</P><P> Dog</P><P> Dog</P><P> Dog</P><P> Cat</P><P> Cat</P><P> Chicken</P><P> Chicken</P><P> Bird</P><P></P><P>Desired Output:</P><P> Dog|1</P><P> Dog|2</P><P> Dog|3</P><P> Dog|4</P><P> Cat|1</P><P> Cat|2</P><P> Cat|3</P><P> Chicken|1</P><P> Chicken|2</P><P> Bird|1</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361987#M821396 devan9876 2020-11-25T16:16:04Z Re: How to reset counter at each unique value in script? https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361988#M821397 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>LOAD FieldName &amp; '|' &amp; AutoNumber(RecNo(), FieldName) as FieldName Inline [</P><P>FieldName</P><P>Dog</P><P>Dog</P><P>Dog</P><P>Dog</P><P>Cat</P><P>Cat</P><P>Chicken</P><P>Chicken</P><P>Bird</P><P>];</P></BODY></HTML> Mon, 07 Aug 2017 14:26:52 GMT https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361988#M821397 Anil_Babu_Samineni 2017-08-07T14:26:52Z Re: How to reset counter at each unique value in script? https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361989#M821398 <HTML><HEAD></HEAD><BODY><P>2 Ways</P><P></P><P>1) Using Peek/Previous</P><P></P><P><STRONG>Fact:</STRONG></P><P><STRONG>LOAD Field</STRONG></P><P><STRONG>FROM ...;</STRONG></P><P></P><P><STRONG>FinalFact:</STRONG></P><P><STRONG>LOAD Field,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(Field = Previous(Field), RangeSum(Peek('Counter'), 1), 1) as Counter</STRONG></P><P><STRONG>Resident Fact</STRONG></P><P><STRONG>Order By Field;</STRONG></P><P></P><P>2) Using AutoNumber</P><P></P><P style="font-size: 13.3333px;"><STRONG>Fact:</STRONG></P><P style="font-size: 13.3333px;"><STRONG>LOAD Field</STRONG></P><P style="font-size: 13.3333px;"><STRONG>FROM ...;</STRONG></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><STRONG>FinalFact:</STRONG></P><P style="font-size: 13.3333px;"><STRONG>LOAD Field,</STRONG></P><P style="font-size: 13.3333px;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; AutoNumber(RecNo(), Field) as Counter</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Resident Fact</STRONG></P><P style="font-size: 13.3333px;"><STRONG>Order By Field;</STRONG></P></BODY></HTML> Mon, 07 Aug 2017 14:27:57 GMT https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361989#M821398 sunny_talwar 2017-08-07T14:27:57Z Re: How to reset counter at each unique value in script? https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361990#M821399 <HTML><HEAD></HEAD><BODY><P>That seems to work.</P><P>Thanks!</P></BODY></HTML> Mon, 07 Aug 2017 14:54:07 GMT https://community.qlik.com/t5/QlikView/How-to-reset-counter-at-each-unique-value-in-script/m-p/1361990#M821399 devan9876 2017-08-07T14:54:07Z