Line

[#1]

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.

[swuehl · Accepted solution]

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;

[#3]

Great. Is really, sorry, i dont use frequently the peek function. I hope will learn soon this function.

Thank you very much!

Regards.

Ivan.