Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi
I think I have read every community thread I could find about this, and no solution I found solves my problem.
I need to extract the latest timestamp from every date in my table.
LOAD * INLINE [
ID, TimeStamp, Value
555, 31-10-2019 23:15, 500
555, 31-10-2019 23:30, 100
555, 31-10-2019 23:46, 100 //I need this value
555, 01-11-2019 00:01, 100
555, 01-11-2019 00:17, 100
555, 01-11-2019 00:32, 100
555, 01-11-2019 00:48, 100
555, 01-11-2019 01:03, 100
555, 01-11-2019 01:19, 100
555, 01-11-2019 01:34, 100
555, 01-11-2019 01:50, 100
555, 01-11-2019 02:05, 100
555, 01-11-2019 02:21, 100
555, 01-11-2019 02:36, 100 //I need this value
];
I need a way to only load the Max(Timestamp) from each date.