Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have three fields called username, timestampvalue , timestamp
username, timestampvalue , timestamp
Satya , 14567 , 20-08-2015 08:40:34
Satya , 34567 , 20-08-2019 08:40:34
raghu , 23456 , 20-08-2016 08:40:34
Now I want to show this data in qlik sense table chart in such way that
last login of user means user name and its timestamp value when imestampvalue is max
means
username , timestamp(for max timestampvalue)
Satya , 20-08-2019 08:40:34 (max one )
raghu , 20-08-2016 08:40:34
kindly suggest , thanks in advance
Dim: username
Exp: Timestamp(Max(timestamp))
That means no use of timestampvalue field .
Could you please explain though answers seems to be fine .
Let me modify my question
I have username , timestamp
satyaban , 20-Jan-2018 12:30:45
satyaban , 21-Jan-2019 12:45:20
Satyaban , 12-07-2020 10:45:25
Raghu , 08-08-2016 09:30:23
Basically I want to show this data in Table Chart in Qlik sense in below format i.t each user and its latest timestamp value
username , timestamp
Satyaban , 12-07-2020 10:45:25
Raghu , 08-08-2016 09:30:23
I have tried by taking username as dimension and below script in Measure of table chart
Max(Date(Floor(Timestamp#(timestamp,'DD-MMM-YYYY hh:mm:ss')),'DD-MMM-YYYY'))
which gives results only max date not actual fully timestamp value as below . But I need same max timestamp value in timestamp column .
Script results (Only shows date value😌😞
username , timestamp
Satyaban , 12-07-2020
Raghu , 08-08-2016
Kindly suggest how to achieve same what should I write in measure section i.t modify the above script