How to retrieve status value per key for max update date

[VamsiBhagavathula1]

Hello,

i am loading the excel into qliksense and i want to retrive status for each key based on max update ts.

Can anyone suggest how could we retrieve this using apply map logic? or could we achive it formula itself in a dimesion.

Thanks

Vamsi

[rwunderlich · Accepted solution]

Assume you data has already been loaded to a Qlik table name "Data". 

Left Join(Data)
LOAD
  KEY,
  FirstSortedValue(STATUS, -UPDATE_TS) as LatestStatus
Resident Data
Group By KEY
; 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[VamsiBhagavathula1]

@rwunderlich thanks for your response. Is there a way to do it with Apply map rather than Left join?

[rwunderlich]

Yes. Use the same Load statement to create a Mapping table instead of Join.  Then use the mapping table in an ApplyMap() or Map Using. 

-Rob