Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Amount ?

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

4 Replies
nizamsha
Not applicable

Re: 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 .

adrianbuzer
Not applicable

Re: Amount ?

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

its_anandrjs
Not applicable

Re: 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.

Not applicable

Re: Amount ?

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

/

Sum([DP amount])

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