Discussion board where members can get started with QlikView.
I need receive lines to observe differences grouped by "bug_id".
Is it possible?
Is it another alternative?
Go to Solution.
You could do it quite similar to my last post, using a reverse sort of your records and peek() function, maybe like:
LOAD recno() as RecID,
(html, codepage is 1252, embedded labels, table is @1);
LOAD *, if(peek(bug_id)=bug_id, peek(date_modified)-date_modified) as Delta
Resident BUGS order by RecID desc;
drop table BUGS;
Great. Is really, sorry, i dont use frequently the peek function. I hope will learn soon this function.
Thank you very much!