If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have three fields called username, timestampvalue , timestamp
username, timestampvalue , timestamp
Satya , 14567 , 20-08-2015 08:40:34Satya , 34567 , 20-08-2019 08:40:34raghu , 23456 , 20-08-2016 08:40:34
Now I want to show this data in qlik sense table chart in such way thatlast login of user means user name and its timestamp value when imestampvalue is max
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
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:45satyaban , 21-Jan-2019 12:45:20Satyaban , 12-07-2020 10:45:25Raghu , 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:25Raghu , 08-08-2016 09:30:23
I have tried by taking username as dimension and below script in Measure of table chart
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😌😞
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