topic Re: How to check if the fields from excel is '#N/A'? in App Development https://community.qlik.com/t5/App-Development/How-to-check-if-the-fields-from-excel-is-N-A/m-p/1406716#M32897 <HTML><HEAD></HEAD><BODY><P>I have advised someone else on the topic in this thread: <A href="https://community.qlik.com/message/1374531">Help with reading Excel #Ref</A></P><P></P><P>Even though the title of the thread only refers to #REF it also includes #N/A values in the suggested solution.</P></BODY></HTML> Sat, 04 Nov 2017 14:11:57 GMT petter 2017-11-04T14:11:57Z How to check if the fields from excel is '#N/A'? https://community.qlik.com/t5/App-Development/How-to-check-if-the-fields-from-excel-is-N-A/m-p/1406715#M32896 <HTML><HEAD></HEAD><BODY><P>Does anyone knows how to check if the fields in a column is '#N/A'? i have tried some methods such as:</P><P></P><P><SPAN style="font-size: 13.3333px;">if(not(left("ColumnName",1) = Chr(35)</SPAN></P><P>if(not(SubField("ColumnName",'N',1) = Chr(35)</P><P></P><P>but nothing seems to work and i'm not sure why. It would only work if i find and replace every fields that are '#N/A' to '#NA' in the excel sheet</P></BODY></HTML> Fri, 03 Nov 2017 06:23:31 GMT https://community.qlik.com/t5/App-Development/How-to-check-if-the-fields-from-excel-is-N-A/m-p/1406715#M32896 Anonymous 2017-11-03T06:23:31Z Re: How to check if the fields from excel is '#N/A'? https://community.qlik.com/t5/App-Development/How-to-check-if-the-fields-from-excel-is-N-A/m-p/1406716#M32897 <HTML><HEAD></HEAD><BODY><P>I have advised someone else on the topic in this thread: <A href="https://community.qlik.com/message/1374531">Help with reading Excel #Ref</A></P><P></P><P>Even though the title of the thread only refers to #REF it also includes #N/A values in the suggested solution.</P></BODY></HTML> Sat, 04 Nov 2017 14:11:57 GMT https://community.qlik.com/t5/App-Development/How-to-check-if-the-fields-from-excel-is-N-A/m-p/1406716#M32897 petter 2017-11-04T14:11:57Z