topic Re: checking null in set analysis in QlikView https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332688#M411522 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>=Count({$&lt;x={"<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">=Len(Trim(y)) = 0</SPAN>"}&gt;}DISTINCT x)</STRONG></SPAN></P></BODY></HTML> Wed, 21 Jun 2017 11:48:37 GMT BalaBhaskar_Qlik 2017-06-21T11:48:37Z checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332683#M411517 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">({$&lt;x</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"isnull(y)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}x</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">this expression gvng me 0 value</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">need to check null value for x field</SPAN></P><P><SPAN style="font-size: 8pt;">x,y are fiel;d names</SPAN></P><P></P></BODY></HTML> Wed, 21 Jun 2017 11:18:03 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332683#M411517 Anonymous 2017-06-21T11:18:03Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332684#M411518 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P><STRONG>=Count({$&lt;x={"<SPAN style="color: #ff0000;">=</SPAN>isnull(y)"}&gt;}x)</STRONG></P></BODY></HTML> Wed, 21 Jun 2017 11:29:12 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332684#M411518 sunny_talwar 2017-06-21T11:29:12Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332685#M411519 <HTML><HEAD></HEAD><BODY><P>Please check this </P><P></P><P><A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P></BODY></HTML> Wed, 21 Jun 2017 11:32:42 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332685#M411519 prma7799 2017-06-21T11:32:42Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332686#M411520 <HTML><HEAD></HEAD><BODY><P>What is your final requirement???</P></BODY></HTML> Wed, 21 Jun 2017 11:33:45 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332686#M411520 PrashantSangle 2017-06-21T11:33:45Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332687#M411521 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=Count({$&lt;x={"<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">=Len(Trim(y)) = 0</SPAN>"}&gt;}x)</STRONG></P></BODY></HTML> Wed, 21 Jun 2017 11:34:13 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332687#M411521 sunny_talwar 2017-06-21T11:34:13Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332688#M411522 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>=Count({$&lt;x={"<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">=Len(Trim(y)) = 0</SPAN>"}&gt;}DISTINCT x)</STRONG></SPAN></P></BODY></HTML> Wed, 21 Jun 2017 11:48:37 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332688#M411522 BalaBhaskar_Qlik 2017-06-21T11:48:37Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332689#M411523 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt;">=</SPAN><SPAN style="font-size: 14pt;"><SPAN style="color: #0000ff;">count</SPAN>({</SPAN><SPAN style="font-size: 14pt;">$-&lt;y={"*"} &gt; } x) </SPAN></P></BODY></HTML> Wed, 21 Jun 2017 16:51:14 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332689#M411523 Anonymous 2017-06-21T16:51:14Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332690#M411524 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>There are some ways to count null values:</P><P><IMG alt="count_null.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167684_count_null.png" style="height: auto;" /></P><P>And here the manual:</P><P><A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P></BODY></HTML> Wed, 21 Jun 2017 16:59:46 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332690#M411524 Sergey_Shuklin 2017-06-21T16:59:46Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332691#M411525 <HTML><HEAD></HEAD><BODY><P>u help, thanq</P></BODY></HTML> Tue, 28 Aug 2018 10:07:02 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332691#M411525 cspindley 2018-08-28T10:07:02Z Re: checking null in set analysis https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332692#M411526 <HTML><HEAD></HEAD><BODY><P>ta</P></BODY></HTML> Tue, 28 Aug 2018 10:46:05 GMT https://community.qlik.com/t5/QlikView/checking-null-in-set-analysis/m-p/1332692#M411526 cspindley 2018-08-28T10:46:05Z