Null Value

[upaliwije]

Hi Friends

I have a worksheet with following fields

Employee    Salary    EPF   ETF   Bonus

XXX               1000      12      2      100

YYY              2000      24     5       20

ZZZ                2000              50

When I load the data I write the following code in the script

salary+EPF+ETF+Bonus as Staff Cost

However in the case of Employee ZZZ I get zero value since EPF and Bonus are null values.

Pls help me to convert null values to 0 value when I load data

[hic · Accepted solution]

Instead of

     salary+EPF+ETF+Bonus as Staff Cost

you should use

     RangeSum(salary,EPF,ETF,Bonus) as Staff Cost

See more in NULL handling in QlikView

HIC

[upaliwije]

Thanks

[#4]

hey upali,

when you load the data in the script use this condition on the fields EPF and Bonus-if(isnull(fieldname),0,fieldname) where fieldname is your EPF and Bonus.then you'll be able to do the required sum as it is i.e.Staff Cost.

also henric's answer would also work.mine is just more elaborated and elementary.