Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

pepito56
New Contributor

Find last price per ref

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

1 Reply

Re: Find last price per ref

May be this

Dimension

proref

Expression

FirstSortedValue(price,  -date)

Community Browser