text associated with max date

[David_K]

Hi Fellow Qlik Sense users,

I have a table that details production, order, dispatch, and returns information. 

If the product is returned it has to go through a series of stages before the customer is refunded or offered an exchange product.  A small table is attached with an example.

I need to be able to report on returned products and where they are in the returns process showing the the Date, Stage, and handler.

I have been able to get date correct in the table using the Max([DATE.autoCalendar.Date]) function, but I am unable to find a way to  get the stage  and handler listed correctly.  

I have tried using =IF(([DATE.autoCalendar.Date])=Max([DATE.autoCalendar.Date]),Returns_Stage), however this  returns a blank value.

Can anyone provide some guidance on how I can achieve the required outcome of  returning details associated with the max date.

Many thanks,

David

[brunobertels]

Hi 

May be this 

FirstSortedValue( Date&' - '&Return_Stage &' - '& Handler,-aggr(max(Date),[Order No],Return_Stage))

Will give you in a KPI Object 

[L_Hop · Accepted solution]

Hi David_K ,

you may apply sum aggregations and get what you want.

I  hope I understand requirements correctly.

regards