topic Re: How to filter when my field sEG have missing value ? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288850#M623201 <HTML><HEAD></HEAD><BODY><P>Thank you it work now.</P><P></P><P>Paul Yeo</P><P>DIrector</P><P>TDS Technology (S) P/L</P><P>Whatsapp +659:261804</P></BODY></HTML> Sun, 08 Jan 2017 10:48:39 GMT paulyeo11 2017-01-08T10:48:39Z How to filter when my field sEG have missing value ? https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288847#M623198 <HTML><HEAD></HEAD><BODY><P>HI All</P><P></P><P>i have try </P><P></P><P>=if(sEG='A11',sEG)</P><P></P><P>it can display those A11 company.</P><P></P><P>may i know how to change the above expression to list missing value ?</P><P></P><P>i Try :-</P><P></P><P>=if(sEG=' ',sEG)</P><P></P><P>it does not work</P><P></P><P>paul</P><P>‌</P></BODY></HTML> Sun, 08 Jan 2017 03:54:52 GMT https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288847#M623198 paulyeo11 2017-01-08T03:54:52Z Re: How to filter when my field sEG have missing value ? https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288848#M623199 <HTML><HEAD></HEAD><BODY><P>try,</P><P></P><P><STRONG>if(len(trim(sEG))=0,sEG)</STRONG></P></BODY></HTML> Sun, 08 Jan 2017 05:21:09 GMT https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288848#M623199 Kushal_Chawda 2017-01-08T05:21:09Z Re: How to filter when my field sEG have missing value ? https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288849#M623200 <HTML><HEAD></HEAD><BODY><P>I don't understand one thing here; if sEG is missing/null() then why are you trying to return sEG?? it will always return a null value, return some other field</P><P></P><P>if(Isnull(sEG), <SPAN style="text-decoration: underline;">otherfield</SPAN>)</P><P>or</P><P><SPAN style="font-size: 13.3333px;">if(Isnull(sEG), </SPAN><SPAN style="text-decoration: underline;">1,0</SPAN><SPAN style="font-size: 13.3333px;">)</SPAN></P><P></P><P>Can you explain the objective for more clarity?</P></BODY></HTML> Sun, 08 Jan 2017 10:42:46 GMT https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288849#M623200 vinieme12 2017-01-08T10:42:46Z Re: How to filter when my field sEG have missing value ? https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288850#M623201 <HTML><HEAD></HEAD><BODY><P>Thank you it work now.</P><P></P><P>Paul Yeo</P><P>DIrector</P><P>TDS Technology (S) P/L</P><P>Whatsapp +659:261804</P></BODY></HTML> Sun, 08 Jan 2017 10:48:39 GMT https://community.qlik.com/t5/QlikView/How-to-filter-when-my-field-sEG-have-missing-value/m-p/1288850#M623201 paulyeo11 2017-01-08T10:48:39Z