Discussion board where members can get started with Qlik Sense.
Additional thought to my previous post. Taking a different approach.
I want to add a new key to each row in my data. But I want the value to start at 1 each time the ID changes in the data.
I'm close. But just can't quite get it to work.
This should work for you:
LOAD * INLINE [
IF(Previous(ID) = ID, Peek(Key) + 1, 1) AS Key
ORDER BY ID;
View solution in original post