topic Re: Null value in set analysis in QlikView

Null value in set analysis

saumyashah90 — Fri, 20 Sep 2013 07:44:51 GMT

Suppose i have blank values in one of the field. how will i calculate it considering it?

For Example : in

i want to calculate count of number whose fieldB value is b,d and null

i did Count(Distinct {<[FieldB]={'b','d',''}>}[FiledA])

and i get output as 2

i want output as 4

Fri, 20 Sep 2013 07:54:22 GMT

try this

your code is right, only the problem of null value these null value defined by two ways like this

suppose you have blank cell then try this

=Count(Distinct {<[FieldB]={'b','d',''}>} FieldA)

suppose you have blank value with space then write this

=Count(Distinct {<[FieldB]={'b','d',' '}>} FieldA)

er_mohit — Fri, 20 Sep 2013 07:55:41 GMT

try this

Count({$<[FieldB]={'b','d',''}>}[FieldA])

or this in text object to count null if it work then use another fields using wildmatch

Count(if([FieldB]='',[FieldA]))

for wildmatch try this

Count(if(wildmatch([FieldB],'b','d',''),[FieldA]))

er_mohit — Fri, 20 Sep 2013 08:09:06 GMT

See the attached file