topic Line in QlikView

Line

Wed, 01 Feb 2012 13:33:11 GMT

Hi guys,

I need receive lines to observe differences grouped by "bug_id".

I have:

Is it possible?

Is it another alternative?

Thank!!..

Regards!.

Ivan.

swuehl — Wed, 01 Feb 2012 13:41:58 GMT

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

(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;

Wed, 01 Feb 2012 15:03:13 GMT

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

Thank you very much!

Regards.

Ivan.