topic Re: Relating fields from two different tables in QlikView https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751336#M267909 <HTML><HEAD></HEAD><BODY><P>Please see attached</P></BODY></HTML> Thu, 22 Jan 2015 16:22:26 GMT robert_mika 2015-01-22T16:22:26Z Relating fields from two different tables https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751331#M267904 <HTML><HEAD></HEAD><BODY><P>I have two tables, both have a field in common.</P><P>Find attached, how do I relate two different fields on these two tables on a straight table in qlikview</P><P>Sheet1= Photo link</P><P>Sheet2= Reg.No</P><P></P><P>LIKE this fields from both tables</P><TABLE border="1" class="jiveBorder" height="54" style="border: 1px solid rgb(0, 0, 0); width: 228px; height: 56px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PHOTO LINK</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"> Reg.No</TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 22 Jan 2015 16:05:20 GMT https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751331#M267904 2015-01-22T16:05:20Z Re: Relating fields from two different tables https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751332#M267905 <HTML><HEAD></HEAD><BODY><P>1) Simply add a table on your document and add the 2 fields.</P><P></P><P>or</P><P></P><P>2) You can add a chart -&gt; straight Table, add the 2 fields as dimension and an expression (write 1 as expression)</P><P></P><P>Let me know</P></BODY></HTML> Thu, 22 Jan 2015 16:09:53 GMT https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751332#M267905 alexandros17 2015-01-22T16:09:53Z Re: Relating fields from two different tables https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751333#M267906 <HTML><HEAD></HEAD><BODY><P>Then you can hide the "1" column in Presentation tab.</P></BODY></HTML> Thu, 22 Jan 2015 16:14:26 GMT https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751333#M267906 robert_mika 2015-01-22T16:14:26Z Re: Relating fields from two different tables https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751334#M267907 <HTML><HEAD></HEAD><BODY><P>Find both tables in the qvw file</P></BODY></HTML> Thu, 22 Jan 2015 16:16:42 GMT https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751334#M267907 2015-01-22T16:16:42Z Re: Relating fields from two different tables https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751335#M267908 <HTML><HEAD></HEAD><BODY><P>Don't understand. Please read question carefully</P></BODY></HTML> Thu, 22 Jan 2015 16:17:57 GMT https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751335#M267908 2015-01-22T16:17:57Z Re: Relating fields from two different tables https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751336#M267909 <HTML><HEAD></HEAD><BODY><P>Please see attached</P></BODY></HTML> Thu, 22 Jan 2015 16:22:26 GMT https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751336#M267909 robert_mika 2015-01-22T16:22:26Z Re: Relating fields from two different tables https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751337#M267910 <HTML><HEAD></HEAD><BODY><P>I got abit confuse. I got it but ur comment helpful<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Jan 2015 16:28:00 GMT https://community.qlik.com/t5/QlikView/Relating-fields-from-two-different-tables/m-p/751337#M267910 2015-01-22T16:28:00Z