Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Bit of a conundrum then 🙂 I don't have Qlik View, will see if i can get it.
Cheers.
Give a try with the below :
If (Len(Trim([Field 1]) )> 0,'Assigned','Not_Assigned')
You are truly wise 🙂
Thank you
Kind Regards
Patrick
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.
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 😞
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 ?
Cheers for the help. See attached.
Count nulls in QA Expert.
Kind Regards
Patrick
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
Bit of a conundrum then 🙂 I don't have Qlik View, will see if i can get it.
Cheers.