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: 
william_fu
Creator II
Creator II

Max value from a column

  How can I calculate the desired Max(Step) column in the script?

IDStepMax(Step)
51962311
52031712
52031722
52185311
52327313
52327323
52327333

I tried with FieldValue, but this gives me the overall max instead of the max by ID:

Left Join ([table])

LOAD Max(FieldValue('Step', recno()))) as MaxStep

Resident

;

1 Solution

Accepted Solutions
sunny_talwar

May be just do this

Left Join (table)

LOAD ID,

     Max(Step) as MaxStep

Resident table

Group By ID;

View solution in original post

1 Reply
sunny_talwar

May be just do this

Left Join (table)

LOAD ID,

     Max(Step) as MaxStep

Resident table

Group By ID;