Qlik Community

Qlik Sense App Development

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

Highlighted
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
CuauSR
New Contributor

Re: Groupby with max date

Hi 

I hope you find this useful

1 Reply
CuauSR
New Contributor

Re: Groupby with max date

Hi 

I hope you find this useful