Discussion Board for collaboration on QlikView Scripting.
Max(Status.LASTOCCURRENCE) as oldLASTOCCURRENCE
where FIRSTOCCURRENCE >= $(OLDLASTOCCURRENCE);
best regardsIngo Placzek
I may be wrong according to your code sample but you must first load your table and then create a new one loading with "RESIDENT".
Hope that helps.
if you load the Script, then he saved the actuall version, i wanted only to make an "update" of these data with the help of an timestamp
OLDLASTOCCURENCE is the timestamp from the actually loaded data and i wanted only to load the data with Select where the Firstoccurence timestamp is newer than the oldlastoccurence