topic Re: Where Condition in QlikView https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816949#M1027455 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P>LOAD</P><P>SaelsOrder_ID,</P><P>SalesOrder_BP,</P><P>SalesOrder_Text,</P><P>mapsubstring('map1',SalesOrder_Text) as Changed</P><P>FROM</P><P>[152744.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1)</P><P>where SaelsOrder_ID= 'Amazon.com'</P><P><IMG __jive_id="78288" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78288_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 16 Feb 2015 22:33:52 GMT robert_mika 2015-02-16T22:33:52Z Where Condition https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816948#M1027454 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How can I write values like 'Amazon's.com' in where condition?</P><P>Usually I write the where condition as follows:</P><P>where Name='<SPAN style="font-size: 13.3333330154419px;">ABC'</SPAN></P><P></P><P>Please help.</P></BODY></HTML> Mon, 16 Feb 2015 22:26:07 GMT https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816948#M1027454 2015-02-16T22:26:07Z Re: Where Condition https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816949#M1027455 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P>LOAD</P><P>SaelsOrder_ID,</P><P>SalesOrder_BP,</P><P>SalesOrder_Text,</P><P>mapsubstring('map1',SalesOrder_Text) as Changed</P><P>FROM</P><P>[152744.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1)</P><P>where SaelsOrder_ID= 'Amazon.com'</P><P><IMG __jive_id="78288" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78288_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 16 Feb 2015 22:33:52 GMT https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816949#M1027455 robert_mika 2015-02-16T22:33:52Z Re: Where Condition https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816950#M1027456 <HTML><HEAD></HEAD><BODY><P><EM>t:</EM></P><P><EM>load * inline [</EM></P><P><EM>str</EM></P><P><EM>Virgilio</EM></P><P><EM>Google</EM></P><P><EM>Yahoo</EM></P><P><EM>Amazon's.com</EM></P><P><EM>];</EM></P><P></P><P><EM>set v='Amazon' &amp; chr(39) &amp; 's.com';</EM></P><P></P><P><EM>v:</EM></P><P><EM>NoConcatenate load str, str as str2 Resident t</EM></P><P><EM>where str = $(v);</EM></P><P><EM><BR /></EM></P><P><EM><IMG alt="1.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78291_1.jpg" style="height: auto; width: auto;" /><BR /></EM></P></BODY></HTML> Mon, 16 Feb 2015 22:34:27 GMT https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816950#M1027456 maxgro 2015-02-16T22:34:27Z Re: Where Condition https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816951#M1027457 <HTML><HEAD></HEAD><BODY><P>Thanks , this works</P></BODY></HTML> Mon, 16 Feb 2015 22:48:46 GMT https://community.qlik.com/t5/QlikView/Where-Condition/m-p/816951#M1027457 2015-02-16T22:48:46Z