Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Expression with max condition

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?

qlikview question.png

For your understanding

PK_U_PLUREN is an key

STATUSURENPERCENTAGE is the value i need

vPeildatum is a variable (date)

PLURENDATE is a date

qlikview question1.png

Thanks a lot,

Matthijs ter Stege

4 Replies

Re: Expression with max condition

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)


talk is cheap, supply exceeds demand
Not applicable

Re: Expression with max condition

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?

qlikview question2.PNG.png

Re: Expression with max condition

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Expression with max condition

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.

qlikview question3.png

Community Browser