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: 
Not applicable

First Row of the Group

Dear All

I have a data in below mentioned format.

I just want to to display on first row of each group.

First row of each group should be the row having least Mfg_Date of the group.

Grouping is based on Product ID.

Kindly suggest.

Product IDNameBatch #Mfg DateQty
1ABC1231-Jan-14232
1ABC45610-Jan-14433
1ABC23415-Jan-1454
2XYZ342-Jan-1476
2XYZ4325-Jan-1454
2XYZ435431-Jan-14545
2XYZ45341-Feb-14544
3QWE423410-Jan-14454
3QWE645625-Jan-14657
4ASD86711-Jan-1454
4ASD5412-Jan-145453
4ASD53425-Jan-14342
4ASD65429-Jan-14323
4ASD64562-Feb-14342
5ZXC53455-Jan-14534
5ZXC423410-Jan-144534
5ZXC43215-Jan-14534
5ZXC545416-Jan-142342
5ZXC656525-Jan-1456
5ZXC876862-Feb-14676

Thanks & Regards

Aqeel Nawaz

5 Replies
Not applicable
Author

Try using rank function and restrict the data using if condition.

jvitantonio
Luminary Alumni
Luminary Alumni

Hi, Please find attached an example of how to achieve this.

Thanks

JV

sreenivas
Creator III
Creator III

PFA of the file

Not applicable
Author

Thanks

Not applicable
Author

Thanks

But I also need Batch # of the first row.