Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need receive lines to observe differences grouped by "bug_id".
I have:
bug_id | user_id | date_modified | I need |
6487 | 19 | 1327984666 | 0 |
6487 | 62 | 1327984666 | 40815 |
6487 | 45 | 1328025481 | 74399 |
6487 | 19 | 1328099880 | |
6488 | 62 | 1328035463 | 0 |
6488 | 74 | 1328035463 | 593 |
6489 | 7 | 1328036056 | 1301 |
6489 | 49 | 1328037357 | |
6490 | 75 | 1328036214 | 90 |
6490 | 80 | 1328036304 | |
6491 | 62 | 1328040799 | 0 |
6491 | 84 | 1328040799 | |
6492 | 62 | 1328041020 | 0 |
6492 | 68 | 1328041020 |
Is it possible?
Is it another alternative?
Thank!!..
Regards!.
Ivan.
You could do it quite similar to my last post, using a reverse sort of your records and peek() function, maybe like:
BUGS:
LOAD recno() as RecID,
bug_id,
user_id,
date_modified,
[I need]
FROM
[http://community.qlik.com/thread/46403?tstart=0]
(html, codepage is 1252, embedded labels, table is @1);
BUGSDELTA:
LOAD *, if(peek(bug_id)=bug_id, peek(date_modified)-date_modified) as Delta
Resident BUGS order by RecID desc;
drop table BUGS;
You could do it quite similar to my last post, using a reverse sort of your records and peek() function, maybe like:
BUGS:
LOAD recno() as RecID,
bug_id,
user_id,
date_modified,
[I need]
FROM
[http://community.qlik.com/thread/46403?tstart=0]
(html, codepage is 1252, embedded labels, table is @1);
BUGSDELTA:
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!
Regards.
Ivan.