topic Re: Re: How to put 2 tables together? - challenging in QlikView https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723136#M673900 <HTML><HEAD></HEAD><BODY><P>Please find the attached file as reference.</P></BODY></HTML> Tue, 22 Jul 2014 18:33:10 GMT 2014-07-22T18:33:10Z How to put 2 tables together? - challenging https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723134#M673898 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have 2 tables in my data model: Accounts - the main one and Filters - the one I want to use for presenting data in a given format:</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Accounts:</STRONG></SPAN></P><TABLE border="1" class="jiveBorder" height="101" style="border: 1px solid rgb(0, 0, 0); width: 533px; height: 86px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Account</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Syntetic</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sign</TH></TR><TR><TD style="padding: 2px;">201-1-7-39</TD><TD style="padding: 2px;">201</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">201-2-3-4-67</TD><TD style="padding: 2px;">201</TD><TD style="padding: 2px;">129</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">202-4-3</TD><TD style="padding: 2px;">202<TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 343px; height: 72px;"><TBODY></TBODY></TABLE></TD><TD style="padding: 2px;">148</TD><TD style="padding: 2px;">-1</TD></TR><TR><TD style="padding: 2px;">459</TD><TD style="padding: 2px;">459</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Filters:</STRONG></SPAN></P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 538px; height: 65px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Filter</STRONG></TH></TR><TR><TD style="padding: 2px;">1.Fixed Assets</TD><TD style="padding: 2px;">1.1 Buildings</TD><TD style="padding: 2px;">201-1</TD></TR><TR><TD style="padding: 2px;">1.Fixed Assets</TD><TD style="padding: 2px;">1.2 Computers</TD><TD style="padding: 2px;">201-2</TD></TR><TR><TD style="padding: 2px;">2.Current Assets</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">202</TD></TR><TR><TD style="padding: 2px;">3. Bank Charges</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">459</TD></TR></TBODY></TABLE><P></P><P>I would like to present the data in sort of the filtered format, where Output=Value * Sign for all the rows from <SPAN style="text-decoration: underline;"><STRONG>Accounts:</STRONG></SPAN> table matching the Filter from <SPAN style="text-decoration: underline;"><STRONG>Filters:</STRONG></SPAN> table</P><P><SPAN style="text-decoration: underline;"><STRONG>Output:</STRONG></SPAN></P><P></P><TABLE border="1" class="jiveBorder" height="119" style="border: 1px solid #000000; width: 704px; height: 113px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Level2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Filter</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Output</STRONG></TH></TR><TR><TD style="padding: 2px;">1.Fixed Assets</TD><TD style="padding: 2px;">1.1 Buildings</TD><TD style="padding: 2px;">201</TD><TD style="padding: 2px;">100*1 + 129 *1</TD></TR><TR><TD style="padding: 2px;">1.Fixed Assets</TD><TD style="padding: 2px;">1.2 Computers</TD><TD style="padding: 2px;">201-2</TD><TD style="padding: 2px;">129 * 1</TD></TR><TR><TD style="padding: 2px;">2.Current Assets</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">202</TD><TD style="padding: 2px;">148*(-1)</TD></TR><TR><TD style="padding: 2px;">3. Bank charges</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">459</TD><TD style="padding: 2px;">35*1</TD></TR></TBODY></TABLE><P></P><P>Challenges:</P><OL><LI>The Output table can be several hundreds row long and changing from one month to another as new accounts are added - in my opinion it prevents use of Set Analysis in the <SPAN style="text-decoration: underline;"><STRONG>Output:</STRONG></SPAN> chart itself (I may be wrong here, but it's not something I can do manually)</LI><LI>Filters are manual, thus they can have different length.<OL><LI>The account can be 461-1, 461-2 and filter can be 461 or</LI><LI>The account can be 203-1-5, 204-1-5 and the filter can be ???-1-5</LI></OL></LI><LI>My <SPAN style="text-decoration: underline;"><STRONG>Accounts:</STRONG></SPAN> table is the core of the data model. Filters table is a manual inline table.</LI></OL><P></P><P>Question:</P><P>How can I create a connection key to put those 2 tables in relation?</P><P></P><P>Any help would be appreciated</P><P>Ki</P></BODY></HTML> Tue, 22 Jul 2014 06:30:08 GMT https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723134#M673898 2014-07-22T06:30:08Z Re: How to put 2 tables together? - challenging https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723135#M673899 <HTML><HEAD></HEAD><BODY><P>Hi Ki Cso, the simple solution is create Link table for this table and Link table must have the all the Combinations against Filter &amp; Account Filter.</P></BODY></HTML> Tue, 22 Jul 2014 18:18:59 GMT https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723135#M673899 2014-07-22T18:18:59Z Re: Re: How to put 2 tables together? - challenging https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723136#M673900 <HTML><HEAD></HEAD><BODY><P>Please find the attached file as reference.</P></BODY></HTML> Tue, 22 Jul 2014 18:33:10 GMT https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723136#M673900 2014-07-22T18:33:10Z Re: How to put 2 tables together? - challenging https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723137#M673901 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 22 Jul 2014 18:47:53 GMT https://community.qlik.com/t5/QlikView/How-to-put-2-tables-together-challenging/m-p/723137#M673901 maxgro 2014-07-22T18:47:53Z