Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Line

Hi guys,

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

I have:

bug_iduser_iddate_modifiedI need
64871913279846660
648762132798466640815
648745132802548174399
6487191328099880
64886213280354630
6488741328035463593
6489713280360561301
6489491328037357
649075132803621490
6490801328036304
64916213280407990
6491841328040799
64926213280410200
6492681328041020

Is it possible?

Is it another alternative?

Thank!!..

Regards!.

Ivan.

1 Solution

Accepted Solutions
MVP
MVP

Line

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;

2 Replies
MVP
MVP

Line

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;

Not applicable

Re: Line

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

Thank you very much!

Regards.

Ivan.