topic Re: Exclude data problem in QlikView https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372233#M1171688 <HTML><HEAD></HEAD><BODY><P>but in Electrical i want to show that plant i want to exclude only vertical = Nacelle</P></BODY></HTML> Fri, 27 Jul 2012 16:06:05 GMT vipin_mishra479 2012-07-27T16:06:05Z Exclude data problem https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372231#M1171686 <HTML><HEAD></HEAD><BODY><P>hiiii, i am upload the qvw file in this file there have a two field vertical and plant</P><P>in this qvw i want exclude two plant 2060 and 2080 from Nacelle</P></BODY></HTML> Fri, 27 Jul 2012 15:51:07 GMT https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372231#M1171686 vipin_mishra479 2012-07-27T15:51:07Z Re: Exclude data problem https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372232#M1171687 <HTML><HEAD></HEAD><BODY><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Vertical, Plant</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 1009</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 1004</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 1005</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 2060</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 2080</P><P>&nbsp;&nbsp;&nbsp; Blade, 2009</P><P>&nbsp;&nbsp;&nbsp; Blade, 1289</P><P>&nbsp;&nbsp;&nbsp; Blade, 1233</P><P>&nbsp;&nbsp;&nbsp; Electrical, 1500</P><P>&nbsp;&nbsp;&nbsp; Electrical, 1555</P><P>&nbsp;&nbsp;&nbsp; Electrical, 2606</P><P>&nbsp;&nbsp;&nbsp; Electrical, 2608</P><P>]</P><P>WHERE Plant &lt;&gt; 2060 AND Plant &lt;&gt; 2080;</P></BODY></HTML> Fri, 27 Jul 2012 16:03:34 GMT https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372232#M1171687 Nicole-Smith 2012-07-27T16:03:34Z Re: Exclude data problem https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372233#M1171688 <HTML><HEAD></HEAD><BODY><P>but in Electrical i want to show that plant i want to exclude only vertical = Nacelle</P></BODY></HTML> Fri, 27 Jul 2012 16:06:05 GMT https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372233#M1171688 vipin_mishra479 2012-07-27T16:06:05Z Re: Exclude data problem https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372234#M1171689 <HTML><HEAD></HEAD><BODY><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Vertical, Plant</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 1009</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 1004</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 1005</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 2060</P><P>&nbsp;&nbsp;&nbsp; Nacelle, 2080</P><P>&nbsp;&nbsp;&nbsp; Blade, 2009</P><P>&nbsp;&nbsp;&nbsp; Blade, 1289</P><P>&nbsp;&nbsp;&nbsp; Blade, 1233</P><P>&nbsp;&nbsp;&nbsp; Electrical, 1500</P><P>&nbsp;&nbsp;&nbsp; Electrical, 1555</P><P>&nbsp;&nbsp;&nbsp; Electrical, 2606</P><P>&nbsp;&nbsp;&nbsp; Electrical, 2608</P><P>]</P><P>WHERE if(Vertical = 'Nacelle', Plant &lt;&gt; 2060 AND Plant &lt;&gt; 2080, Plant);</P></BODY></HTML> Fri, 27 Jul 2012 16:40:55 GMT https://community.qlik.com/t5/QlikView/Exclude-data-problem/m-p/372234#M1171689 Nicole-Smith 2012-07-27T16:40:55Z