Expression with max condition

[#1]

hello,

I'm stuck in a QlikView expression.

I have built two formulas and they have to be merged. (see picture)

does anyone have a clue how to solve this problem?

For your understanding

PK_U_PLUREN is an key

STATUSURENPERCENTAGE is the value i need

vPeildatum is a variable (date)

PLURENDATE is a date

Thanks a lot,

Matthijs ter Stege

[Gysbert_Wassenaar]

Use a variable to calculate the max pk_u_pluren and use the variable in the max statusurenpercentage expression.

vMax: =max({...etc..} PK_U_PLUREN)

expression: max({$<PK_U_PLUREN={$(vMax)}>} STATUSURENPERCENTAGE)

[#3]

Thanks for the reply.

There is not one value, but there are many to fill. For each order i need to recalculate the PK_U_PLUREN. does that work with a variable also?

[Gysbert_Wassenaar]

Not with set analysis expressions. The set is calculated once for the entire chart, not per row. If you need a different max per row then you need to use if statements. Or precalculate the values in the script in a summary table.

[#5]

Thanks a lot,

I have changed something in de database and only save the value changes.

I have a field with status on a higher level and when the status change,  only the differences between the old data and the new data is saved. So i can now use this formula.