Counting blank cells

[Patman]

Please advise, I need to count blank cells.

I have tried to add a calculation to the table

If ([Field 1]=' ','Not_Assigned','Assigned')  - but everything is set to Assigned (even though Field 1 has some blanks 😞

I have also tried 

NULLCOUNT({<[Field 1]={" "}>}[Field 1]) but this returns an incorrect value.

Kind regards in advance

Patrick

[trdandamudi]

Give a try with the below :

If (Len(Trim([Field 1]) )> 0,'Assigned','Not_Assigned')

[Patman]

You are truly wise 🙂

Thank you

Kind Regards

Patrick

[trdandamudi]

You are welcome.

If you think you got your answer can you please close the thread by marking it correct answer, so that it will be helpful for the other users.

[Patman]

Cheers for the feedback.

Worked for one column and not another 😞

then did a replace Null in the table with Not Assigned and that worked, but when I went to count 'Not Assigned' it returns 0.

Is it always this difficult 😞

[trdandamudi]

It is not difficult at all...

If you can post a sample app with the data I can take a look and help you out. Because when you say "Null" is it really a null or it has spaces ?

[Patman]

Cheers for the help. See attached.

Count nulls in QA Expert.

Kind Regards

Patrick

[trdandamudi · Accepted solution]

Sorry, I completely forgot it is Qliksense. I cannot open your file on my side as I do not have desktop version. Can you put this sample in Qlikview and send it please. So that I can look at it and propose a solution that you can input into Qlik Sense.

Thanks

[Patman · Accepted solution]

Bit of a conundrum then 🙂 I don't have Qlik View, will see if i can get it.

Cheers.