topic Re: Expression with max condition in QlikView

Expression with max condition

Thu, 10 Oct 2013 08:18:03 GMT

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

Re: Expression with max condition

Gysbert_Wassenaar — Thu, 10 Oct 2013 08:31:40 GMT

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)

Re: Expression with max condition

Thu, 10 Oct 2013 08:43:49 GMT

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?

Re: Expression with max condition

Gysbert_Wassenaar — Thu, 10 Oct 2013 08:48:28 GMT

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.

Re: Expression with max condition

Fri, 11 Oct 2013 05:15:55 GMT

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.