Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi David_K ,
you may apply sum aggregations and get what you want.
I hope I understand requirements correctly.
regards
Hi
May be this
FirstSortedValue( Date&' - '&Return_Stage &' - '& Handler,-aggr(max(Date),[Order No],Return_Stage))
Will give you in a KPI Object
Hi David_K ,
you may apply sum aggregations and get what you want.
I hope I understand requirements correctly.
regards