topic Basic Calculation (Addition) not working right in Transform in QlikView

Basic Calculation (Addition) not working right in Transform

Fri, 02 Mar 2012 17:00:12 GMT

Hi All,

The Calculation

SECT A +SECT B/ 2 (if SECT A and SECT B not null)

SECT A + SECT B / 1 ( if SECT A is 0 and SECT B is not null)

is working fine in Table Chart, but not in Any other Charts

Below is the formula i used in expression

( if(isnull([SECT A])=0,[SECT A],0) + if(isnull([SECT B])=0,[SECT B],0) )

/
( if(isnull([SECT A]),0,1) + if(isnull([SECT B]),0,1) )

phaneendra_kunc — Sat, 03 Mar 2012 04:50:59 GMT

Hi Neelima,

Can you post a sample...

Regards,

Phani

tanelry — Mon, 05 Mar 2012 15:35:24 GMT

I think you can simplify your calculation to just this:

RangeAvg([SECT A],[SECT B])

Range functions are usually immune to null values which makes them handy.