Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

yashpace
New Contributor II

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!

1 Solution

Accepted Solutions
Highlighted
CuauSR
New Contributor

Re: Groupby with max date

Hi 

I hope you find this useful

1 Reply
Highlighted
CuauSR
New Contributor

Re: Groupby with max date

Hi 

I hope you find this useful