Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to write the Expression in qlikview for this:
(Sum(AP amount) + Sum(BP amount) + Sum(CP amount))
/
Sum(DP amount)
Regards,
Helen
what u written is correct ,but when the year is on selection it show the value for current year only so make sure what u want .
If the field names have spaces in them you will need to use square brackets: e.g Sum( [AP Amount] )
Elaborate more about the expression if in the expression if it is fields then you have to use
(Sum([AP amount]) + Sum([BP amount]) + Sum([CP amount]))
/
Sum([DP amount])
or if AP,BP,CP,DP are conditions then you have to use SET analysis.
Sum([AP amount] + [BP amount] + [CP amount])
/
Sum([DP amount])
Alternatively, the commutative property should give you the above expression.