topic Qlik Sense - Count and select Null values in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-Count-and-select-Null-values/m-p/1246861#M24916 <HTML><HEAD></HEAD><BODY><P>I would like the ability to select the results associated to Null values on a field (sentiment).&nbsp; For example, I want to find the respondents who who did not answer the question regarding the overall satisfaction with their service.&nbsp; If I only select 'show null values' the values are presented, but I'm unable to select those entries and display the related results.&nbsp; </P><P></P><P>Is it possible to count the nulls and present those as a value such as 'no response'?&nbsp; </P><P><IMG alt="Screen Shot 2017-02-09 at 3.09.23 PM.png" class="jive-image image-1" src="/legacyfs/online/152690_Screen Shot 2017-02-09 at 3.09.23 PM.png" style="height: auto;" /></P></BODY></HTML> Thu, 09 Feb 2017 21:14:52 GMT joshakehurst 2017-02-09T21:14:52Z Qlik Sense - Count and select Null values https://community.qlik.com/t5/App-Development/Qlik-Sense-Count-and-select-Null-values/m-p/1246861#M24916 <HTML><HEAD></HEAD><BODY><P>I would like the ability to select the results associated to Null values on a field (sentiment).&nbsp; For example, I want to find the respondents who who did not answer the question regarding the overall satisfaction with their service.&nbsp; If I only select 'show null values' the values are presented, but I'm unable to select those entries and display the related results.&nbsp; </P><P></P><P>Is it possible to count the nulls and present those as a value such as 'no response'?&nbsp; </P><P><IMG alt="Screen Shot 2017-02-09 at 3.09.23 PM.png" class="jive-image image-1" src="/legacyfs/online/152690_Screen Shot 2017-02-09 at 3.09.23 PM.png" style="height: auto;" /></P></BODY></HTML> Thu, 09 Feb 2017 21:14:52 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Count-and-select-Null-values/m-p/1246861#M24916 joshakehurst 2017-02-09T21:14:52Z Re: Qlik Sense - Count and select Null values https://community.qlik.com/t5/App-Development/Qlik-Sense-Count-and-select-Null-values/m-p/1246862#M24917 <HTML><HEAD></HEAD><BODY><P>May be fix the issue in the script:</P><P></P><P><STRONG>LOAD If(Len(Trim(Sentiments)) = 0, 'No Response', Sentiments) as Sentiments</STRONG></P><P></P><P>now you will have no response instead of null and you can select it</P></BODY></HTML> Thu, 09 Feb 2017 21:43:16 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Count-and-select-Null-values/m-p/1246862#M24917 sunny_talwar 2017-02-09T21:43:16Z Re: Qlik Sense - Count and select Null values https://community.qlik.com/t5/App-Development/Qlik-Sense-Count-and-select-Null-values/m-p/1246863#M24918 <HTML><HEAD></HEAD><BODY><P>Yes, this is the right approach to assign a value to the Nulls in the load script.&nbsp; Thanks for the reply!</P></BODY></HTML> Thu, 09 Feb 2017 23:33:57 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Count-and-select-Null-values/m-p/1246863#M24918 joshakehurst 2017-02-09T23:33:57Z