Peek based on group

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

Could you please deliver me a script that can handle in this kind of situation

The desired Output depends on the last score from a series in column 'Score'.

Thanks and best regards,

Cornelis

Re: Peek based on group

Gysbert_Wassenaar — Thu, 25 Aug 2016 11:31:29 GMT

Again, sort the data by ID in descending order and then use the Previous function to check the score of the previous record (the next higher ID because of the reversed sort order). You can check for empty strings and null values with Len(Trim( ...something...))=0.

Temp

LOAD

ID,

Score

FROM

... source ...

;

Result:

LOAD

ID,

Score,

If(Len(Trim(Previous(Score)))=0 and Score='K','K') as Output

RESIDENT

Temp

;

DROP TABLE Temp;

topic Re: Peek based on group in QlikView

Peek based on group

Re: Peek based on group