topic Count column value using If condition in QlikView

Count column value using If condition

lawrance — Mon, 30 Oct 2017 21:48:10 GMT

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 — Mon, 30 Oct 2017 23:21:09 GMT

May be this

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

Anonymous — Tue, 31 Oct 2017 06:26:49 GMT

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 — Tue, 31 Oct 2017 08:17:31 GMT

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