topic How to avoid the NA in QlikView https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105728#M366207 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>In the bar chart dimension i want to avoid the null and NA value, For Null I can select the suppress null value&nbsp; option, but for NA how to do that in a dimension, what is condition for this? i have attache the file</P></BODY></HTML> Mon, 29 Aug 2016 11:06:09 GMT manoranjan_d 2016-08-29T11:06:09Z How to avoid the NA https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105728#M366207 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>In the bar chart dimension i want to avoid the null and NA value, For Null I can select the suppress null value&nbsp; option, but for NA how to do that in a dimension, what is condition for this? i have attache the file</P></BODY></HTML> Mon, 29 Aug 2016 11:06:09 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105728#M366207 manoranjan_d 2016-08-29T11:06:09Z Re: How to avoid the NA https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105729#M366208 <HTML><HEAD></HEAD><BODY><P>Replace your Dimension with this?</P><P></P><P>If(DimName&lt;&gt;'NA', DimName)</P></BODY></HTML> Mon, 29 Aug 2016 11:09:14 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105729#M366208 Anonymous 2016-08-29T11:09:14Z Re: How to avoid the NA https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105730#M366209 <HTML><HEAD></HEAD><BODY><P>Attached Qvw for ur solution.</P></BODY></HTML> Mon, 29 Aug 2016 11:13:01 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105730#M366209 mayankraoka 2016-08-29T11:13:01Z Re: How to avoid the NA https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105731#M366210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can be done in 2 ways:</P><P></P><P>1. Script Side:</P><P></P><P>LOAD dept, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; presentabsent, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; student, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; amount, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; SECTION</P><P>FROM</P><P><C></C></P><P>(ooxml, embedded labels, table is Sheet1)</P><P>where dept &lt;&gt;'NA';</P><P></P><P>2. Layout side:&nbsp; Check yellow marked condition</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135857_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Mon, 29 Aug 2016 11:14:10 GMT https://community.qlik.com/t5/QlikView/How-to-avoid-the-NA/m-p/1105731#M366210 amit_saini 2016-08-29T11:14:10Z