topic Re: How to link both table with all dimensions in QlikView https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101776#M755125 <HTML><HEAD></HEAD><BODY><P>Hi Neville,</P><P></P><P>It is not possible to create an&nbsp; association (link both tables) based on the data you have.</P><P>You must find a relation between Provience and Country or city.</P><P></P><P>Br,</P><P>KC</P></BODY></HTML> Mon, 24 Sep 2018 12:48:43 GMT jyothish8807 2018-09-24T12:48:43Z How to link both table with all dimensions https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101773#M755122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could you please see why Province is not coming when the both tables are loaded?</P><P></P><P>Thanks In advance</P><P></P><P>Neville</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101773#M755122 nevilledhamsiri 2020-11-25T16:16:04Z Re: How to link both table with all dimensions https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101774#M755123 <HTML><HEAD></HEAD><BODY><P>Hi, I think there must be a relationship between two tables, some common field.</P><P></P><P>TABLE1:</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">LOAD PROVINCE, SALES, <STRONG>CommonField</STRONG></SPAN></P><P>FROM <D> (ooxml, embedded labels, table is Sheet1);</D></P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">TABLE2:</SPAN></P><P>LOAD COUNTRY, CITY, POPULATION, <SPAN style="font-size: 13.3333330154419px;"><STRONG>CommonField</STRONG></SPAN></P><P>FROM <D> (ooxml, embedded labels, table is Sheet1);</D></P><P></P><P>Then you can join them or leave as they are.</P></BODY></HTML> Mon, 24 Sep 2018 11:33:07 GMT https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101774#M755123 andrey_krylov 2018-09-24T11:33:07Z Re: How to link both table with all dimensions https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101775#M755124 <HTML><HEAD></HEAD><BODY><P>I see it loaded in the Table view:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214284_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Mon, 24 Sep 2018 11:40:01 GMT https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101775#M755124 trdandamudi 2018-09-24T11:40:01Z Re: How to link both table with all dimensions https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101776#M755125 <HTML><HEAD></HEAD><BODY><P>Hi Neville,</P><P></P><P>It is not possible to create an&nbsp; association (link both tables) based on the data you have.</P><P>You must find a relation between Provience and Country or city.</P><P></P><P>Br,</P><P>KC</P></BODY></HTML> Mon, 24 Sep 2018 12:48:43 GMT https://community.qlik.com/t5/QlikView/How-to-link-both-table-with-all-dimensions/m-p/101776#M755125 jyothish8807 2018-09-24T12:48:43Z