Discussion Board for collaboration on QlikView Scripting.
This seems like an easy problem, but i couldnt find a solution.
Is it possible to count up the same values in the Script, so that it starts counting from 1 everytime the Value changes?
Thanks for your time, Lukas
Go to Solution.
if(Value <> peek('Value', -1), 1, peek('Output', -1) + 1) as Output
ORDER BY Value
Note though that depending on your source you might not be able to ORDER BY. If this is the case load first into a temporary table, then use a RESIDENT load, and ORDER that.
AutoNumber(RecNo(),Value) as CalculatedOutput
(html, codepage is 1252, embedded labels, table is @1);
Thanks Marcus, worked out really well!