Counting Blank Cells

[hammermill21]

Hello,

I have data that has blanks in the Inspection Bar code section and I want to be able to get a count of those that are blank. I tried:

count({<[Inspection Bar Code]={" "}>}[Inspection Bar Code]) and it does not seem to be working.

I have attached a pic of the data that is being pulled into Qlik Sense Server.

Thank you!!

[hammermill21]

Yes it is a unique key that is generated every time someone creates a new record and it is never repeated.

[sunny_talwar]

I don't see a reason why it wouldn't work.... Have you made any selections which might be excluding them? Would you be able to share a sample to look at this?

[hammermill21]

I'm wondering if it's something in my script that I can't figure out. Would you want to see the script maybe?

[sunny_talwar · Accepted solution]

Since you mentioned script, why don't you create a flag in the script

If(Len(Trim([Inspection Bar Code])) = 0, 1, 0) as NullFlag

and then use this in your expression

Count({<NullFlag = {1}>} [Firex Monthly Inspection Key])

[hammermill21]

Hey Sunny,

Thank you for the help! Your answer was correct but I had something within my script that needed to be changed also.

Thank you!

[Patman]

I have a similar problem:

count({<[Field 1]={""}>}[Field 1])

Why does this not work?