1 Reply Latest reply: Mar 13, 2018 12:36 PM by Sunny Talwar RSS

    Find last price per ref

    el pepito

      Hi everyone,

       

      I'm a qliksence beginer and i'm trying to find the last price value of each ref in my base.

      The table is like

      prorefdateprice
      A03/03/1850
      A03/03/17100
      A04/10/1617
      B

      01/01/18

      23
      B01/02/1824
      C10/12/1732
      C10/11/1723

       

      I would like to find only (A,50) (B,24) and (C,32).

      I'd tried some expression like firstsortedvalue(price,Aggr(min(date),proref)) and using aggregrate but it still not working.

       

      I thinks I'm close to find but....

      Does anyone can help me?

       

      Thank you