Discussion board where members can get started with QlikView.
I have got the following script :
[Product Category]: LOAD ID as ID ,If(ID <> Previous(ID), category_name, '') as category_name ,If(ID <>Previous(ID), Order, Order+1) as Order
,[Product Category] as Value ; LOAD Distinct '$(vOrder)' as Order ,'$(vcategory_name)' as category_name , ID , [Product Category] as [Product Category] Resident TmpProducts Order By ID
And that produces the following table, ex:
Long Sleeve shit
But I am trying to achieve this:
For each ID, the order should start at 70 (already in variable) and increment until it reaches the number of values by that ID.
Could you help me please achieve this goal. I was think of Loop, but I want to use it as last resource because of performance.
Thank you very much.
,If(ID <>Previous(ID), Order, peek(Order)+1) as Order
View solution in original post
Thanks for your help.... You were a time saver (: