4 Replies Latest reply: Jun 6, 2014 4:38 AM by Javier Martinez Juanas RSS

    Problem to filter registers in my script

      I'm starting developing in qlikview and i don't know how to filter registers in my script:


      LOAD

        TEXT(INVENTTRANSID)   as INVENTTRANSID,

        TEXT(DIMENSION3_)      as PROYECT,

        TEXT(PURCHID) & '-' &  TEXT(LINENUM) as PURCHLINE,

        TEXT(PURCHPRICE)       as UNITPRICE,

        TEXT(CURRENCYCODE)     as COIN,

        DATE(CONFIRMEDDLV)     as CONFIRMEDDLV

      FROM

      [$(Ruta_QVD)\PURCHLINE.qvd] (qvd)

      WHERE DATAAREAID = 'tase' ;

      LOAD

        TEXT(CURRENCYCODE) as COIN,

        DATE(FROMDATE)    as CHANGE_DATE,

        NUM(EXCHRATE)          as CHANGE

      FROM

      [$(Ruta_QVD)\EXCHRATES.qvd] (qvd)

      WHERE DATAAREAID = 'tase' ;

       

      I only want the "CHANGE" that fulfill condition : the max "change_date" that is smaller than confirmeddlv. So I would get the right exchange but i don't know how to do it.

       

      Thanks and sorry for my English.