topic Re: 'Contains' logic ?! in QlikView https://community.qlik.com/t5/QlikView/Contains-logic/m-p/514198#M192081 <HTML><HEAD></HEAD><BODY><P>Though the requirement is not very clear, I guess you need to use <STRONG>set analysis </STRONG>using<STRONG> P() element</STRONG>.</P></BODY></HTML> Thu, 24 Oct 2013 06:09:23 GMT tresB 2013-10-24T06:09:23Z 'Contains' logic ?! https://community.qlik.com/t5/QlikView/Contains-logic/m-p/514196#M192079 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P><BR />I have the base data table below <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P><OBJECT classid="CLSID:A806E1D7-B077-415E-AF08-28AFE10DDF4A" height="304" width="496"><PARAM name="_Version" value="720896" /><PARAM name="_ExtentX" value="13123" /><PARAM name="_ExtentY" value="8043" /><PARAM name="_StockProps" value="0" /><PARAM name="DocName" value="C:\analyser\REPORTS\docidtest.qvw" /><PARAM name="UserName" value="" /><PARAM name="Password" value="" /><PARAM name="Publisher" value="" /><PARAM name="AccessMode" value="0" /><PARAM name="AllowDialog" value="1" /><PARAM name="SRC" value="" /><PARAM name="AutoScan" value="1" /><PARAM name="ProductLevel" value="62633808" /><PARAM name="ObjectID" value="Document\TB01" /><BR /><PARAM name="DocName" value="C:\analyser\REPORTS\docidtest.qvw" /><BR /><PARAM name="ObjectID" value="Document\TB01" /></OBJECT></P><P>I want to then select a supplier (via variable) and then have this pickup all documents that have this supplier and related data i.e. I choose supplier 'A'&nbsp; in the variable via an input field, and the chart then shows all docs (including all suppliers) and related sales data that at least have supplier 'A'.</P><P></P><P>Currently all my logic just filters out all the other suppliers (&amp; documents) as soon as I choose supplier 'A'.</P><P></P><P>Any ideas please (qvw also attached) ?</P><P></P><P>Thanks in advance</P><P>Nick</P></BODY></HTML> Wed, 23 Oct 2013 15:43:55 GMT https://community.qlik.com/t5/QlikView/Contains-logic/m-p/514196#M192079 2013-10-23T15:43:55Z Re: 'Contains' logic ?! https://community.qlik.com/t5/QlikView/Contains-logic/m-p/514197#M192080 <HTML><HEAD></HEAD><BODY><P>Requirement is not clear What you want achieve ?</P><P></P><P>Vikas</P></BODY></HTML> Thu, 24 Oct 2013 05:58:30 GMT https://community.qlik.com/t5/QlikView/Contains-logic/m-p/514197#M192080 vikasmahajan 2013-10-24T05:58:30Z Re: 'Contains' logic ?! https://community.qlik.com/t5/QlikView/Contains-logic/m-p/514198#M192081 <HTML><HEAD></HEAD><BODY><P>Though the requirement is not very clear, I guess you need to use <STRONG>set analysis </STRONG>using<STRONG> P() element</STRONG>.</P></BODY></HTML> Thu, 24 Oct 2013 06:09:23 GMT https://community.qlik.com/t5/QlikView/Contains-logic/m-p/514198#M192081 tresB 2013-10-24T06:09:23Z