topic Re: Relationship between tables in QlikView https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837097#M657974 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this (it's not very elegant but it should work) :</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Full potential of 2015:</SPAN></P><P>=sum({&lt;[Year of Production]={"2015"}&gt;*&lt;[Year]={"2015"}&gt;} Potential*Qtd)</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Full potential by product:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=sum(if([Year of Production]=Year,Qtd*Potential))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Xavier.<BR /></SPAN></P></BODY></HTML> Mon, 11 May 2015 19:53:02 GMT 2015-05-11T19:53:02Z Relationship between tables https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837096#M657973 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P></P><P>I'm trying to solve this problem.</P><P></P><P>How do I cross the tables below to calculate:</P><P></P><P>Full potential of 2015</P><P>(Answer should be 800)</P><P></P><P>or Full potential by product</P><P>&nbsp;&nbsp; (Answer should be A = 3700 ; B = 300)</P><P></P><P>Tks a lot!!</P><P></P><P>Sales per Year</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>City</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Cód</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year of Production</STRONG></TH><TH style="color: #ffffff; padding: 2px; text-align: center; background-color: #6690bc;" valign="middle"><STRONG>Qtd</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">São Paulo</TD><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">2015</TD><TD style="padding: 2px; text-align: center;">5</TD></TR><TR><TD style="padding: 2px; text-align: center;">Rio de Janeiro</TD><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">2014</TD><TD style="padding: 2px; text-align: center;">3</TD></TR><TR><TD style="padding: 2px; text-align: center;">São Paulo</TD><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;">2014</TD><TD style="padding: 2px; text-align: center;">7</TD></TR><TR><TD style="padding: 2px; text-align: center;">Rio de Janeiro</TD><TD style="padding: 2px; text-align: center;">3</TD><TD style="padding: 2px; text-align: center;">2013</TD><TD style="padding: 2px; text-align: center;">10</TD></TR><TR><TD style="padding: 2px; text-align: center;">Rio de Janeiro</TD><TD style="padding: 2px; text-align: center;">6</TD><TD style="padding: 2px; text-align: center;">2015</TD><TD style="padding: 2px; text-align: center;">5</TD></TR></TBODY></TABLE><P></P><P>Models</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Cód</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">A</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">A</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">A</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">A</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">B</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">B</TD></TR><TR><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">B</TD></TR></TBODY></TABLE><P></P><P></P><P>Potential of maintenance</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Potential</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2014</TD><TD style="padding: 2px;">150</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2013</TD><TD style="padding: 2px;">170</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2015</TD><TD style="padding: 2px;">60</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 11 May 2015 18:07:54 GMT https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837096#M657973 2015-05-11T18:07:54Z Re: Relationship between tables https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837097#M657974 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this (it's not very elegant but it should work) :</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Full potential of 2015:</SPAN></P><P>=sum({&lt;[Year of Production]={"2015"}&gt;*&lt;[Year]={"2015"}&gt;} Potential*Qtd)</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Full potential by product:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=sum(if([Year of Production]=Year,Qtd*Potential))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Xavier.<BR /></SPAN></P></BODY></HTML> Mon, 11 May 2015 19:53:02 GMT https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837097#M657974 2015-05-11T19:53:02Z Re: Relationship between tables https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837098#M657975 <HTML><HEAD></HEAD><BODY><P>See attached</P></BODY></HTML> Mon, 11 May 2015 20:15:32 GMT https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837098#M657975 Anonymous 2015-05-11T20:15:32Z Re: Relationship between tables https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837099#M657976 <HTML><HEAD></HEAD><BODY><P>Yet another solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />&nbsp; - and I attached the QVW too:</P><P></P><P><IMG alt="2015-05-11 #4.PNG" class="jive-image image-1" src="/legacyfs/online/86210_2015-05-11 #4.PNG" style="height: auto;" /></P><P></P><P><IMG alt="2015-05-11 #5.PNG" class="jive-image image-2" src="/legacyfs/online/86211_2015-05-11 #5.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 11 May 2015 21:31:24 GMT https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837099#M657976 petter 2015-05-11T21:31:24Z Re: Relationship between tables https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837100#M657977 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution could be also:</P><P></P><P><IMG alt="QlikCommunity_Thread_163545_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86215_QlikCommunity_Thread_163545_Pic1.JPG" style="height: auto;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_163545_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/86216_QlikCommunity_Thread_163545_Pic2.JPG" style="height: auto;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 12 May 2015 00:07:20 GMT https://community.qlik.com/t5/QlikView/Relationship-between-tables/m-p/837100#M657977 MarcoWedel 2015-05-12T00:07:20Z