I'm not quite sure if this will help but have you tried the Peek function?
It allows you to see the previous rows data.
peek([Fieldname]) will give you the value of Fieldname from the previous record read.
For more information, in Qlikview click on help->contents->index tab->type in "peek".
Hope this helps!
Thank you, but I don't think peek() will help, because the rows I need to exclude may not be immediately preceding each other - they may not be in consecutive rows within the dataset. What I'd like is the QlikView equivalent of this PL/SQL:
SELECT * from data WHERE issueid IN (SELECT issueid FROM data WHERE action = 'Withdrawn' AND type = 'Long Term Rating');