Discussion board where members can get started with Qlik Sense.
I've created a daily incremental extract but I need to validate and track some occurrence IDs.
So my data is in this format:
I'd like to be able to calculate 3 things:
So a table that looks like this:
And another table that looks like:
I would then be able to work out the last one from the second table above.
Go to Solution.
Temp: LOAD Date, ID FROM "https://community.qlik.com/message/1289550" (html, codepage is 1252, embedded labels, table is @1); LOAD *,If(ID=Peek(ID),1,0) as Flag Resident Temp Order By ID; Drop Table Temp;