Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joshakehurst
Not applicable

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
Not applicable

Re: Qlik Sense - Count and select Null values

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

2 Replies
sunny_talwar
Not applicable

Re: Qlik Sense - Count and select Null values

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
Not applicable

Re: Qlik Sense - Count and select Null values

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