Find last price per ref

[Anonymous]

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

proref	date	price
A	03/03/18	50
A	03/03/17	100
A	04/10/16	17
B	01/01/18	23
B	01/02/18	24
C	10/12/17	32
C	10/11/17	23

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

[sunny_talwar]

May be this

Dimension

proref

Expression

FirstSortedValue(price,  -date)