topic How to select records corresponds to null values? in QlikView https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729856#M1081365 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am having a table say</P><P></P><P>Tab1:</P><P>Col1, Col2</P><P>a1, 1</P><P>a2,</P><P>a3, 2</P><P>a4,</P><P>a5, 3</P><P></P><P>Now I have to select those column's value from Col1 where Col2 is null in Qlikview.</P><P></P><P>Can we get it using expression or we need to work at backend?</P><P></P><P>Regards,</P><P>Balraj</P></BODY></HTML> Tue, 08 Jul 2014 07:01:42 GMT Anonymous 2014-07-08T07:01:42Z How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729856#M1081365 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am having a table say</P><P></P><P>Tab1:</P><P>Col1, Col2</P><P>a1, 1</P><P>a2,</P><P>a3, 2</P><P>a4,</P><P>a5, 3</P><P></P><P>Now I have to select those column's value from Col1 where Col2 is null in Qlikview.</P><P></P><P>Can we get it using expression or we need to work at backend?</P><P></P><P>Regards,</P><P>Balraj</P></BODY></HTML> Tue, 08 Jul 2014 07:01:42 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729856#M1081365 Anonymous 2014-07-08T07:01:42Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729857#M1081366 <HTML><HEAD></HEAD><BODY><P>You must set in the script dummy values for null in order to make it selectable in your tables ...</P></BODY></HTML> Tue, 08 Jul 2014 07:05:40 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729857#M1081366 alexandros17 2014-07-08T07:05:40Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729858#M1081367 <HTML><HEAD></HEAD><BODY><P>Is it possible through expression at UI?</P></BODY></HTML> Tue, 08 Jul 2014 07:07:31 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729858#M1081367 Anonymous 2014-07-08T07:07:31Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729859#M1081368 <HTML><HEAD></HEAD><BODY><P>You can use something like:</P><P></P><P>If(Isnull(Sum(MyValue)), 'NO', Sum(MyValue))</P><P></P><P>and in multibox you can set a similar expression</P></BODY></HTML> Tue, 08 Jul 2014 07:11:14 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729859#M1081368 alexandros17 2014-07-08T07:11:14Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729860#M1081369 <HTML><HEAD></HEAD><BODY><P>HI</P><P>Please go through the thread ,</P><P><A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P>you may fing ans to your questions</P></BODY></HTML> Tue, 08 Jul 2014 07:12:22 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729860#M1081369 sasikanth 2014-07-08T07:12:22Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729861#M1081370 <HTML><HEAD></HEAD><BODY><P>Hi Balraj</P><P></P><P>you can restrict them in the script itself like using Load * from where Col 2=null</P><P>This is the dummy code just to give u an overview about that</P><P></P><P>Regards</P><P>Kushal Thakral</P></BODY></HTML> Tue, 08 Jul 2014 07:12:35 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729861#M1081370 kushalthakral 2014-07-08T07:12:35Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729862#M1081371 <HTML><HEAD></HEAD><BODY><P>I have to display only those value where they are null in the table.</P><P></P><P>I am not asking to use aggregate function...</P></BODY></HTML> Tue, 08 Jul 2014 07:15:10 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729862#M1081371 Anonymous 2014-07-08T07:15:10Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729863#M1081372 <HTML><HEAD></HEAD><BODY><P>In a dimension you mean? In that case use :</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">If(Isnull(MyField), 'NO', MyField)</SPAN></P></BODY></HTML> Tue, 08 Jul 2014 07:18:13 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729863#M1081372 alexandros17 2014-07-08T07:18:13Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729864#M1081373 <HTML><HEAD></HEAD><BODY><P>Yes, If one dimension(D1) is null than I have to select other dimension(D2) values for those null values.</P><P></P><P>Above expression is not working...</P></BODY></HTML> Tue, 08 Jul 2014 07:23:16 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729864#M1081373 Anonymous 2014-07-08T07:23:16Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729865#M1081374 <HTML><HEAD></HEAD><BODY><P>Obviously you put your field name in place of MyField....</P></BODY></HTML> Tue, 08 Jul 2014 07:29:53 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729865#M1081374 alexandros17 2014-07-08T07:29:53Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729866#M1081375 <HTML><HEAD></HEAD><BODY><P>Yes, I have put my field name only...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 08 Jul 2014 07:32:11 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729866#M1081375 Anonymous 2014-07-08T07:32:11Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729867#M1081376 <HTML><HEAD></HEAD><BODY><P>See the attached file</P></BODY></HTML> Tue, 08 Jul 2014 07:36:48 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729867#M1081376 er_mohit 2014-07-08T07:36:48Z Re: How to select records corresponds to null values? https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729868#M1081377 <HTML><HEAD></HEAD><BODY><P>Are you sure they are Null?</P><P>please try the following and let me know ...</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">If(Isnull(MyField) or Trim(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">MyField</SPAN>)='', 'NO', MyField)</SPAN></P></BODY></HTML> Tue, 08 Jul 2014 07:44:11 GMT https://community.qlik.com/t5/QlikView/How-to-select-records-corresponds-to-null-values/m-p/729868#M1081377 alexandros17 2014-07-08T07:44:11Z