Discussion board where members can get started with QlikView.
I have the below field containing the below data;
I need the script to generate a number for each order number, but start a new sequence once it reaches a new Order.
Please can someone assist?
Thanks in Advance
May be this:
AutoNumber(RowNo(), WHO) as Sequence
May be use this?
LOAD *, AutoNumber(rowno(),FieldName) as Row Inline [
If(WHO = Previous(WHO), RangeSum(Peek('Sequence'), 1), 1) as Sequence
Order by WHO;
This option will give better performance for a larger dataset
If(Previous(WHO) = WHO, Rangesum(1, peek('Sequence')), 1) as Sequence
Thanks This worked ! You Champion
Good, You may close this thread by flag Correct answer. Hope Sunny's 2 solutions should work. But, I don't know how your data seems. Any how some what Left Join works for you
Close this thread, Please