Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
satyaban
Contributor III
Contributor III

how to show values of one field based on max value of other field in Tabular structure in qlik sense

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

Labels (2)
3 Replies
tresesco
MVP
MVP

Dim: username

Exp: Timestamp(Max(timestamp))

satyaban
Contributor III
Contributor III
Author

That means no use of timestampvalue field .

Could you please explain though answers seems to be fine . 

satyaban
Contributor III
Contributor III
Author

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