group by in qlikview

[Anonymous]

Hi All

I have table like below.

i want to restrict the table to show only Max(line_no) on each unique loaded file. i want output as below. Please help me how we can fix.

[sunny_talwar]

Not sure if you are looking for something like this:

LOAD Loaded_File

          Max(Line_No) as Max Line_No

Resident sourceTable

Group By Loaded_File

HTH

Best,

Sunny

[buzzy996]

try sunindia advice,hopes it works.