Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yashpace
Contributor III
Contributor III

Groupby with max date

Hey all, I am stuck in converting this data in one line -

I want to get the field values only associated with the Max Date of [FileNameDate], Group by [PKey]

PKeyWEIGHTService LevelUPG_CODEFileNameDate
50242355891OLN00010.5GROUNDMI/with ATP disabled09/08/2019
50242355891OLN00011.4GROUND-07/08/2019
50242355891OLN00010.5GROUNDMI/with ATP disabled08/08/2019

 

Result Should Look Like This: - 

50242355891OLN00010.5GROUNDMI/with ATP disabled09/08/2019

 

 

Will really appreciate all help and opinions. Thanks a ton!

Labels (2)
1 Solution

Accepted Solutions
CuauSR
Contributor
Contributor

Hi 

I hope you find this useful

View solution in original post

1 Reply
CuauSR
Contributor
Contributor

Hi 

I hope you find this useful