Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Midastouch365
Contributor II
Contributor II

Qlik Null Count

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.

2 Solutions

Accepted Solutions
Andrei_Cusnir
Support
Support

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

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

Midastouch365
Contributor II
Contributor II
Author

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

View solution in original post

4 Replies
Andrei_Cusnir
Support
Support

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

Help users find answers! Don't forget to mark a solution that worked for you! 🙂
Midastouch365
Contributor II
Contributor II
Author

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

Midastouch365
Contributor II
Contributor II
Author

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
Support
Support

Hello @Midastouch365,

 

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

Help users find answers! Don't forget to mark a solution that worked for you! 🙂