topic count fields in QlikView

count fields

Wed, 07 Mar 2012 10:38:24 GMT

hi all,

in a table with 5 fields:

ID,

where fields A, B, C, D have numerical values, i want to add a field to this table in my LOAD script telling me the number of fields (only A, B, C and D) that are 0.

Example:

ID	A	B	C	D
XYZ	5	0	2	1

Adding the niew field the table shall look like this:

ID	A	B	C	D	# of zeros
XYZ	5	0	2	1	1

Thanks a lot for some ideas!

count fields

swuehl — Wed, 07 Mar 2012 10:47:49 GMT

LOAD

ID,

-1*rangesum(A=0,B=0,C=0, D=0) as NrOfZeros

from Table;

count fields

CELAMBARASAN — Wed, 07 Mar 2012 10:55:32 GMT

Hi,

Try with this

Load

ID,

RangeSum(If(A=0,1),If(B=0,1),If(C=0,1),If(B=0,1)) as NumCount

From..

Celambarasan

count fields

jagan — Wed, 07 Mar 2012 11:19:09 GMT

Hi,

Use the following script, with a little change to Stefan's script. Used fabs() instead -1*

LOAD

fabs(RangeSum(A=0, B=0, C=0, D=0)) AS zeroCount;

LOAD * INLINE [

A, B, C, D

1, 0, 0, 1

76, 0, 8, 7

0, 0, 0, 0

];

Regards,

Jagan.