Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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?
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.
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.