topic Re: Help needed for the file attched.Please. in QlikView https://community.qlik.com/t5/QlikView/Help-needed-for-the-file-attched-Please/m-p/543828#M1139774 <HTML><HEAD></HEAD><BODY><P>If i have understood right, may be you can try something:</P><P></P><P>=If([Level Desc 4]='Atlanta - Georgia', WildMatch([Product Long Description], 'AMC*<STRONG>'),</STRONG> [Product Long Description])</P><P></P><P>Note: be careful of 'Atlanta - Geogia' string, i am not sure if i wrote right.</P><P></P><P>Edit: Corrected the brace was missing</P></BODY></HTML> Thu, 19 Sep 2013 13:51:53 GMT tresB 2013-09-19T13:51:53Z Help needed for the file attched.Please. https://community.qlik.com/t5/QlikView/Help-needed-for-the-file-attched-Please/m-p/543826#M1139772 <HTML><HEAD></HEAD><BODY><P>Please help me with the attched file.</P><P></P><P>Thanks a lot.</P></BODY></HTML> Thu, 19 Sep 2013 13:39:53 GMT https://community.qlik.com/t5/QlikView/Help-needed-for-the-file-attched-Please/m-p/543826#M1139772 2013-09-19T13:39:53Z Re: Help needed for the file attched.Please. https://community.qlik.com/t5/QlikView/Help-needed-for-the-file-attched-Please/m-p/543827#M1139773 <HTML><HEAD></HEAD><BODY><P>Use "&lt;Expression&gt;" as the listbox field and define it as</P><P>=if([left([Product Long Description],3='AMC', [Product Long Description])</P><P></P><P>-Rob</P></BODY></HTML> Thu, 19 Sep 2013 13:45:27 GMT https://community.qlik.com/t5/QlikView/Help-needed-for-the-file-attched-Please/m-p/543827#M1139773 rwunderlich 2013-09-19T13:45:27Z Re: Help needed for the file attched.Please. https://community.qlik.com/t5/QlikView/Help-needed-for-the-file-attched-Please/m-p/543828#M1139774 <HTML><HEAD></HEAD><BODY><P>If i have understood right, may be you can try something:</P><P></P><P>=If([Level Desc 4]='Atlanta - Georgia', WildMatch([Product Long Description], 'AMC*<STRONG>'),</STRONG> [Product Long Description])</P><P></P><P>Note: be careful of 'Atlanta - Geogia' string, i am not sure if i wrote right.</P><P></P><P>Edit: Corrected the brace was missing</P></BODY></HTML> Thu, 19 Sep 2013 13:51:53 GMT https://community.qlik.com/t5/QlikView/Help-needed-for-the-file-attched-Please/m-p/543828#M1139774 tresB 2013-09-19T13:51:53Z