Discussion board where members can get started with Qlik Sense.
How can I calculate the desired Max(Step) column in the script?
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
Go to Solution.
May be just do this
Left Join (table)
Max(Step) as MaxStep
Group By ID;