Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to discard null values in Qlikview

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

1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: How to discard null values in Qlikview

Hi Tutan,

NumSum() function may do this job. Let try

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

Regards,

Sokkorn

3 Replies
Sokkorn
Honored Contributor

Re: How to discard null values in Qlikview

Hi Tutan,

NumSum() function may do this job. Let try

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

Regards,

Sokkorn

Not applicable

Re: How to discard null values in Qlikview

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)) +......

Not applicable

Re: How to discard null values in Qlikview

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

Community Browser