topic Need Help?? in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/692471#M1066457 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i have table..</P><P>Highlighted lines description, we are not using</P><P>how to exclude....??</P><P></P><P>here starting with <STRONG>Allowance</STRONG> and <STRONG>Memo </STRONG>need to exclude.....</P><P></P><P><STRONG>Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description</STRONG></P><P>AR100000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff6600;"><STRONG>Test</STRONG></SPAN></P><P>AR100001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Advertising display</P><P>AR100002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Advertising abc</P><P>AR100003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Advertising flying</P><P>AR100004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff6600;"><STRONG>Allowance - New Store</STRONG></SPAN></P><P>AR100005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff9900;"><STRONG>Allowance -Audit</STRONG></SPAN></P><P>AR100006&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-1</P><P>AR100007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-2</P><P>AR100008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-3</P><P>AR100009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-4</P><P>AR100010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff9900;"><STRONG>Memo - abc</STRONG></SPAN></P><P>AR100011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff9900;"><STRONG>Memo - xyz</STRONG></SPAN></P><P></P><P>Hope you understand ..</P><P></P><P>Thanks in Advance....</P></BODY></HTML> Tue, 02 Sep 2014 17:07:01 GMT paulwalker 2014-09-02T17:07:01Z Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/692471#M1066457 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i have table..</P><P>Highlighted lines description, we are not using</P><P>how to exclude....??</P><P></P><P>here starting with <STRONG>Allowance</STRONG> and <STRONG>Memo </STRONG>need to exclude.....</P><P></P><P><STRONG>Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description</STRONG></P><P>AR100000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff6600;"><STRONG>Test</STRONG></SPAN></P><P>AR100001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Advertising display</P><P>AR100002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Advertising abc</P><P>AR100003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Advertising flying</P><P>AR100004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff6600;"><STRONG>Allowance - New Store</STRONG></SPAN></P><P>AR100005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff9900;"><STRONG>Allowance -Audit</STRONG></SPAN></P><P>AR100006&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-1</P><P>AR100007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-2</P><P>AR100008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-3</P><P>AR100009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor-4</P><P>AR100010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff9900;"><STRONG>Memo - abc</STRONG></SPAN></P><P>AR100011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff9900;"><STRONG>Memo - xyz</STRONG></SPAN></P><P></P><P>Hope you understand ..</P><P></P><P>Thanks in Advance....</P></BODY></HTML> Tue, 02 Sep 2014 17:07:01 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/692471#M1066457 paulwalker 2014-09-02T17:07:01Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/692472#M1066458 <HTML><HEAD></HEAD><BODY><P>So you want to get rid of the descriptions that are highlighted?</P></BODY></HTML> Tue, 02 Sep 2014 17:11:01 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/692472#M1066458 2014-09-02T17:11:01Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/692473#M1066459 <HTML><HEAD></HEAD><BODY><P>You could exclude in your load script with this WHERE</P><P></P><P><EM>where not wildmatch( 'Allowance - New Store' , '<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #ff6600;"><STRONG>Allowance</STRONG></SPAN>*' , '<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #ff9900;"><STRONG>Memo</STRONG></SPAN>*' ', '<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #ff6600;"><STRONG>Test</STRONG></SPAN>*')</EM></P></BODY></HTML> Tue, 02 Sep 2014 17:14:28 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/692473#M1066459 Anonymous 2014-09-02T17:14:28Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/692474#M1066460 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P>LOAD</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Description</P><P>FROM</P><P><C></C></P><P>(txt, codepage is 1252, embedded labels, delimiter is ',', msq)</P><P>Where not WildMatch(Description,'Allowance*',Memo*) ;</P><P></P><P>regards , harish</P></BODY></HTML> Tue, 02 Sep 2014 17:27:31 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/692474#M1066460 munna1317 2014-09-02T17:27:31Z