How Create The Sequence As per Items in Script

[dilipkumard13]

Dear Qlik,

I Have 1 Requirement as i need to Give an Sequence Num as Per the Items.

it Should Start From 1.

Ex :

Index	Sequence	Item	Date
1	1	Orange	01-Sep-18
2	2	Orange	02-Sep-18
3	3	Orange	03-Sep-18
4	1	Apple	04-Sep-18
5	2	Apple	05-Sep-18
6	1	PineApple	06-Sep-18
7	2	PineApple	07-Sep-18
8	3	PineApple	08-Sep-18

[sunny_talwar · Accepted solution]

May be try this

AutoNumber(RowNo(), Item)

[sunny_talwar]

Or using Peek() function

If(Peek('Item') = Item, RangeSum(Peek('Sequence'), 1), 1) as Sequence

But make sure to sort the data using Order by before you apply AutoNumber or Peek()