topic Re: Amount ? in QlikView

Amount ?

Wed, 14 May 2014 09:54:57 GMT

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

nizamsha — Wed, 14 May 2014 10:09:49 GMT

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 .

Anonymous — Wed, 14 May 2014 10:19:55 GMT

If the field names have spaces in them you will need to use square brackets: e.g Sum( [AP Amount] )

its_anandrjs — Wed, 14 May 2014 11:52:58 GMT

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.

Wed, 14 May 2014 12:07:33 GMT

Sum([AP amount] + [BP amount] + [CP amount])

Sum([DP amount])

Alternatively, the commutative property should give you the above expression.