Qlik Null Count

[Midastouch365]

Hello! I'm new to QlikSense, and I'm stuck on a problem. I imported my data into QlikSense already but there are some missing cells in my table represented by "-". To count these missing cells in my report, how do I write the function to count the number of cells with "-" or null in them?

I tried using:

Count(is null("FieldName") 

If(FieldName = " ", Count(FieldName), SourceFIle = " ")

Please advise on how to best write this function to account for the null cells in the table.

[Andrei_Cusnir · Accepted solution]

Hello,

I think this post [1] can help you out with your requirement. More specifically the answer posted by Jagan where he suggest to use the expression "=Sum(if(isnull(invdate) OR Len(Trim(invdate)) = 0, 1, 0))". I have used the expression in my test dataset and this is the result:

As you can see, the expression in my KPI has counted properly 6 null values.

I hope that this information was helpful.

---

[1] https://community.qlik.com/t5/QlikView-App-Dev/how-to-count-null-value-in-a-field/td-p/263345

[Midastouch365 · Accepted solution]

Thank you so much @Andrei_Cusnir ! Yes, this solved the problem.

[Midastouch365]

I tried applying the same function in my dimension to reflect the null data, but it's showing up as "Invalid Dimension" 

How do I address this?

[Andrei_Cusnir]

Hello @Midastouch365,

You will have to use it as Measure not Dimension, otherwise you will get the error "Invalid Dimension" as you are getting.