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
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?