How to discard null values in Qlikview

[#1]

Hi,

I have a straight table with 14 columns consisting of numerical data. In one or two columns I have null data which I represent by the symbol "-". Now, if I write an expression in the 15th column of the straight table as col(1)+col(2)....+col(14) I get the sum as "-".

If I remove the particular columns consisting of the null values, for eg: if col(2) is null (represnted by "-") & I remove it from the expression for summing up as col(1)+col(3)...

I get the summation value.

How can I discard null values and add up only those columns which has value in it. The values are all numerical.

Thanks to All in advance for suggestions,

Tutan

[Sokkorn · Accepted solution]

Hi Tutan,

NumSum() function may do this job. Let try

=NumSum(Col(1),Col(2),Col(3))

Regards,

Sokkorn

[#3]

Sokkorn may have the best technique there but you can also put IF statements to check for the null values:

If(Isnull(Col(1)), 0, Col(1)) + If(Isnull(Col(2), 0, Col(2)) +......

[#4]

works perfectly fine...Many Thanks for the help.