Discussion Board for collaboration on QlikView Scripting.
I have to write the Expression in qlikview for this:
(Sum(AP amount) + Sum(BP amount) + Sum(CP amount))
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]))
or if AP,BP,CP,DP are conditions then you have to use SET analysis.
Sum([AP amount] + [BP amount] + [CP amount])
Alternatively, the commutative property should give you the above expression.