Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Dimension
proref
Expression
FirstSortedValue(price, -date)