Discussion Board for collaboration on QlikView Scripting.
A simplified example of the data which I'm loading into my model looks something like this:
I need to calculate a column in the script to keep track of the number of orders the customer has ever placed. i.e.:
This will allow me to tell that OrderID=10009 was John's third order ever. How do I calculate the PurchaseNumber column?
Go to Solution.
AutoNumber(OrderId, Customer) as PurchaseNumber
Brilliant, thank you!!