topic Re: Join in the front End in QlikView https://community.qlik.com/t5/QlikView/Join-in-the-front-End/m-p/1346380#M414289 <HTML><HEAD></HEAD><BODY><P>May be this -</P><P>Area as dimension and expression as -</P><P>Only({&lt;Area={$(=chr(39)&amp;concat(Country,chr(39)&amp;','&amp;chr(39))&amp;chr(39))}&gt;}Mapping)</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161805_Capture.PNG" style="height: 158px; width: 620px;" /></P></BODY></HTML> Mon, 01 May 2017 21:11:51 GMT Digvijay_Singh 2017-05-01T21:11:51Z Join in the front End https://community.qlik.com/t5/QlikView/Join-in-the-front-End/m-p/1346379#M414288 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have tow tables.</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="100"><TBODY><TR><TD class="xl63" height="17" width="47">Area</TD><TD class="xl63" style="border-left: none;" width="53">Mapping</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Canada</TD><TD class="xl64" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">China</TD><TD class="xl64" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">France</TD><TD class="xl64" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Germany</TD><TD class="xl64" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">India</TD><TD class="xl64" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Italy</TD><TD class="xl64" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Japan</TD><TD class="xl64" style="border-top: none; border-left: none;">N</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">UK</TD><TD class="xl64" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">USA</TD><TD class="xl64" style="border-top: none; border-left: none;">N</TD></TR></TBODY></TABLE><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="72"><TBODY><TR><TD class="xl65" height="17" width="72">Country</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Australia</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Canada</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">China</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">France</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Germany</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">India</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Italy</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Japan</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">USA</TD></TR></TBODY></TABLE><P></P><P>Expected output:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="136"><TBODY><TR><TD class="xl65" height="17" width="72">Country</TD><TD class="xl67" style="border-left: none;" width="64">Mapping</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Australia</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Canada</TD><TD>N</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">China</TD><TD>N</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">France</TD><TD>Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Germany</TD><TD>Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">India</TD><TD>Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Italy</TD><TD>Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">Japan</TD><TD>N</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">USA</TD><TD>N</TD></TR></TBODY></TABLE><P></P><P></P><P>This can be achieved thru LOAD script without any issue.</P><P></P><P>But how to achieve through Expression in a Chart?</P><P>Thought this is a sample data, in my real scenario, I have few similar requirements.</P><P>Few expressions, which didn't work for me:</P><P>Only({&lt;Mapping=p({&lt;Country=p(Area)&gt;})&gt;} Mapping)</P><P>Only({&lt;Country=p(Area)&gt;} Mapping)</P><P>Only({&lt;Area=p({&lt;Country=p(Area)&gt;})&gt;}Mapping)</P></BODY></HTML> Mon, 01 May 2017 18:03:10 GMT https://community.qlik.com/t5/QlikView/Join-in-the-front-End/m-p/1346379#M414288 Saravanan_Desingh 2017-05-01T18:03:10Z Re: Join in the front End https://community.qlik.com/t5/QlikView/Join-in-the-front-End/m-p/1346380#M414289 <HTML><HEAD></HEAD><BODY><P>May be this -</P><P>Area as dimension and expression as -</P><P>Only({&lt;Area={$(=chr(39)&amp;concat(Country,chr(39)&amp;','&amp;chr(39))&amp;chr(39))}&gt;}Mapping)</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/161805_Capture.PNG" style="height: 158px; width: 620px;" /></P></BODY></HTML> Mon, 01 May 2017 21:11:51 GMT https://community.qlik.com/t5/QlikView/Join-in-the-front-End/m-p/1346380#M414289 Digvijay_Singh 2017-05-01T21:11:51Z