Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joshakehurst
Partner - Contributor III
Partner - Contributor III

Qlik Sense - Count and select Null values

I would like the ability to select the results associated to Null values on a field (sentiment).  For example, I want to find the respondents who who did not answer the question regarding the overall satisfaction with their service.  If I only select 'show null values' the values are presented, but I'm unable to select those entries and display the related results. 

Is it possible to count the nulls and present those as a value such as 'no response'? 

Screen Shot 2017-02-09 at 3.09.23 PM.png

1 Solution

Accepted Solutions
sunny_talwar

May be fix the issue in the script:

LOAD If(Len(Trim(Sentiments)) = 0, 'No Response', Sentiments) as Sentiments

now you will have no response instead of null and you can select it

View solution in original post

2 Replies
sunny_talwar

May be fix the issue in the script:

LOAD If(Len(Trim(Sentiments)) = 0, 'No Response', Sentiments) as Sentiments

now you will have no response instead of null and you can select it

joshakehurst
Partner - Contributor III
Partner - Contributor III
Author

Yes, this is the right approach to assign a value to the Nulls in the load script.  Thanks for the reply!