Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Save the highest value into another field

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

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

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

<Source>

;

left join (Debe)

load

  max(debe) as MaxDebe

Resident Debe;

View solution in original post

1 Reply
JonnyPoole
Employee
Employee

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

<Source>

;

left join (Debe)

load

  max(debe) as MaxDebe

Resident Debe;

View solution in original post