topic Re: Blank values with expression? in QlikView https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568019#M1108352 <HTML><HEAD></HEAD><BODY><P>if the ISNULL does not work, try this :</P><P></P><P>if(len(trim(Instruction))=0, Instruction)</P></BODY></HTML> Wed, 12 Mar 2014 16:47:10 GMT agilos_mla 2014-03-12T16:47:10Z Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568015#M1108348 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have straight table. I would need to show the values which have 'Instructions' with blanks</P><P></P><P>I used the below expression.</P><P></P><P> =If(Instruction='',Instruction)</P><P></P><P></P><P>will it gives the values only with blanks?</P></BODY></HTML> Wed, 12 Mar 2014 16:40:43 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568015#M1108348 2014-03-12T16:40:43Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568016#M1108349 <HTML><HEAD></HEAD><BODY><P>May be </P><P></P><P>IF(ISNULL(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">Instruction</SPAN>), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">Instruction</SPAN>)</P></BODY></HTML> Wed, 12 Mar 2014 16:44:16 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568016#M1108349 MK_QSL 2014-03-12T16:44:16Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568017#M1108350 <HTML><HEAD></HEAD><BODY><P>a better way to identify the nulls and blanks is to use Len(Trim(&lt;Field name&gt;)) = 0</P><P></P><P>In your case:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=If(Len(Trim(Instruction)))=0', 'Instruction')</SPAN></P></BODY></HTML> Wed, 12 Mar 2014 16:45:44 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568017#M1108350 srchilukoori 2014-03-12T16:45:44Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568018#M1108351 <HTML><HEAD></HEAD><BODY><P>Thanks. Just wrote it.</P></BODY></HTML> Wed, 12 Mar 2014 16:45:49 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568018#M1108351 2014-03-12T16:45:49Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568019#M1108352 <HTML><HEAD></HEAD><BODY><P>if the ISNULL does not work, try this :</P><P></P><P>if(len(trim(Instruction))=0, Instruction)</P></BODY></HTML> Wed, 12 Mar 2014 16:47:10 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568019#M1108352 agilos_mla 2014-03-12T16:47:10Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568020#M1108353 <HTML><HEAD></HEAD><BODY><P>ISNULL() doesn't identify blank spaces.</P></BODY></HTML> Wed, 12 Mar 2014 16:50:17 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568020#M1108353 srchilukoori 2014-03-12T16:50:17Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568021#M1108354 <HTML><HEAD></HEAD><BODY><P>Thanks. it's not showing blanks . instead showing all. Any solution please.</P><P></P><P>Edit: will this works with table box?</P></BODY></HTML> Wed, 12 Mar 2014 17:08:28 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568021#M1108354 2014-03-12T17:08:28Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568022#M1108355 <HTML><HEAD></HEAD><BODY><P>Thanks. This is not taking blank values. Any solution please</P></BODY></HTML> Wed, 12 Mar 2014 17:14:08 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568022#M1108355 2014-03-12T17:14:08Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568023#M1108356 <HTML><HEAD></HEAD><BODY><P>As always, give us your sample data !</P></BODY></HTML> Wed, 12 Mar 2014 17:21:10 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568023#M1108356 MK_QSL 2014-03-12T17:21:10Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568024#M1108357 <HTML><HEAD></HEAD><BODY><P>Maybe it's a real white space: soft blanks (Chr(32)), hard blanks (Chr(160)), the tab character (Chr(09)) <SPAN style="font-size: 10pt; line-height: 1.5em;">. </SPAN></P><P></P><P>So try,&nbsp; for soft blanks ,&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">if(len(trim(Instruction))=chr(32), Instruction)</SPAN></P></BODY></HTML> Wed, 12 Mar 2014 17:24:08 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568024#M1108357 agilos_mla 2014-03-12T17:24:08Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568025#M1108358 <HTML><HEAD></HEAD><BODY><P>Sorry please find attached.</P></BODY></HTML> Wed, 12 Mar 2014 17:33:49 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568025#M1108358 2014-03-12T17:33:49Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568026#M1108359 <HTML><HEAD></HEAD><BODY><P>please check...</P></BODY></HTML> Wed, 12 Mar 2014 17:42:58 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568026#M1108359 MK_QSL 2014-03-12T17:42:58Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568027#M1108360 <HTML><HEAD></HEAD><BODY><P>Also, if you want ID having NULL instruction...use below expression in list box expression...</P><P></P><P>=IF(LEN(TRIM(Instruction))=0,ID)</P></BODY></HTML> Wed, 12 Mar 2014 17:45:06 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568027#M1108360 MK_QSL 2014-03-12T17:45:06Z Re: Blank values with expression? https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568028#M1108361 <HTML><HEAD></HEAD><BODY><P>Thanks. That's perfect.</P></BODY></HTML> Wed, 12 Mar 2014 17:57:22 GMT https://community.qlik.com/t5/QlikView/Blank-values-with-expression/m-p/568028#M1108361 2014-03-12T17:57:22Z