Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

william_fu
Contributor 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

Re: Max value from a column

May be just do this

Left Join (table)

LOAD ID,

     Max(Step) as MaxStep

Resident table

Group By ID;

1 Reply

Re: Max value from a column

May be just do this

Left Join (table)

LOAD ID,

     Max(Step) as MaxStep

Resident table

Group By ID;

Community Browser