topic Re: Simple Expression in QlikView

Simple Expression

Fri, 24 Oct 2014 07:52:20 GMT

Hi All,

My expression,

SUM('BRO_ORC'+'AGE_ORC'+'GRO_ORC'+'DIRECT_ME')-('ORC_COM')

where 'BRO_ORC','AGE_ORC,'GRO_ORC, 'DIRECT_ME' and 'ORC_COM' are field name of my table.

Even expression status shows "OK" , the calculation is not done.

Regards,

Priyantha.

Re: Simple Expression

alexandros17 — Fri, 24 Oct 2014 07:55:01 GMT

Try This

SUM(BRO_ORC+AGE_ORC+GRO_ORC+DIRECT_ME-ORC_COM)

or this

SUM(BRO_ORC+AGE_ORC+GRO_ORC+DIRECT_ME)-SUM(ORC_COM)

let me know

Re: Simple Expression

Fri, 24 Oct 2014 08:05:40 GMT

Both are not working.......

Re: Simple Expression

alexandros17 — Fri, 24 Oct 2014 08:07:31 GMT

Replace sum with rangesum so you have:

rangesum(BRO_ORC,AGE_ORC,GRO_ORC,DIRECT_ME)

Re: Simple Expression

jonathandienst — Fri, 24 Oct 2014 08:25:25 GMT

If any one field is null, the row will evaluate as null, regardless of the value of the other fields. RangeSum() will fix that. Your complete expression will then be:

Sum(RangeSum(BRO_ORC, AGE_ORC, GRO_ORC, DIRECT_ME, -ORC_COM))

HTH

Jonathan