topic Re: Save the highest value into another field in QlikView

Save the highest value into another field

Thu, 18 Sep 2014 17:01:24 GMT

Hi,

I have a numeric field called 'debe' and I would like to add a new field called 'maximun' containing the highest value in the 'debe'.

Something like:

load

debe,

maximun(debe) as maximun

from...;

Which command / sintax I need?

Thanks

JonnyPoole — Thu, 18 Sep 2014 17:27:37 GMT

This will do it. Joins the record with the max(debe) to all records in the load and stores the max under the new field MaxDebe

Debe:

LOAD

debe

FROM

;

left join (Debe)

load

max(debe) as MaxDebe

Resident Debe;