Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master
Master

Hi Tutan,

NumSum() function may do this job. Let try

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

Regards,

Sokkorn

View solution in original post

3 Replies
Sokkorn
Master
Master

Hi Tutan,

NumSum() function may do this job. Let try

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

Regards,

Sokkorn

Not applicable
Author

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
Author

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