2 Replies Latest reply: Feb 1, 2012 10:03 AM by Ivan Troisi RSS

    Line

    Ivan Troisi

      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.

        • Line
          Stefan Wühl

          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;