Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saumyashah90
Specialist
Specialist

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

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
Master II
Master II

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
Master II
Master II

See the attached file