Solved: How to retrieve status value per key for max updat... - Qlik Community

VamsiBhagavathula1 · ‎2024-05-21

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 · ‎2024-05-21

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
;

rwunderlich · ‎2024-05-21

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
;

VamsiBhagavathula1 · ‎2024-05-22

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

rwunderlich · ‎2024-05-22

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

How to retrieve status value per key for max update date