Count column value using If condition

[lawrance]

Hi all,

Please help me to solve this in QlikView.

I want to count the column but the column value should not be null or zero using QlikView Script.

For Example,

Date	A	B	C	D	Total
10/11/17	1	1	0	1	3
10/12/17	1	1	1	1	4
10/13/17	0	1	1	1	3
10/14/17	1	1	1	1	4
10/15/17	0	0	0	1	1
10/16/17	1	1	1	1	4

Thanks,

Lawrance A

[sunny_talwar]

May be this

RangeSum(A, B, C, D) as Total

[Anonymous]

first handle all the null value in all the columns  if(len(A)=0,0,A)

then use A+B+C+D as Total

[sunny_talwar]

But why not handle them both at the same time using RangeSum?