Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

saumyashah90
Valued Contributor

Null value in set analysis

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

For Example : in

FieldA

FieldB

1a
2b
3
4d
5


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

3 Replies
Not applicable

Re: Null value in set analysis

try this

hi

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
Honored Contributor II

Re: Null value in set analysis

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
Honored Contributor II

Re: Null value in set analysis

See the attached file

Community Browser