topic Re: Problem: Concatenate Tables in QlikView https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505495#M481124 <HTML><HEAD></HEAD><BODY><P>please fund attahment</P><P>hope it heps u..</P><P>u have to join</P></BODY></HTML> Tue, 22 Oct 2013 15:48:09 GMT preminqlik 2013-10-22T15:48:09Z Problem: Concatenate Tables https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505491#M481120 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hello Community,</P><P style="text-align: left;"></P><P style="text-align: left;">I have two tables, one of them contains errors, the other includes quantities produced. There are certain columns that exist in both tables and should be used as dimensions. So I have concatenated the two tables... The problem is that in the first Table a column DefectNo exists, that in the second Table does not exist. But this column is to be used as a dimension in the chart. If the DefectNo column is used in the chart, there is no assignment of Defects and Produced Quantities anymore (see Table 2 in QlikView-File). Is it possible to exclude the DefectNo in calculating the amount? The appendix provides a simple QlikView example and a Excel-File with the required result.</P><P style="text-align: left;"></P><P style="text-align: left;">Thank you!</P></BODY></HTML> Tue, 22 Oct 2013 15:05:09 GMT https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505491#M481120 2013-10-22T15:05:09Z Re: Problem: Concatenate Tables https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505492#M481121 <HTML><HEAD></HEAD><BODY><P>you can use Set Analysis to overule any selections in DefectNo</P><P> </P><P><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">DefectNo</SPAN><SPAN style="font-size: 8pt;">&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Produced</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Tue, 22 Oct 2013 15:07:55 GMT https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505492#M481121 p_verkooijen 2013-10-22T15:07:55Z Re: Problem: Concatenate Tables https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505493#M481122 <HTML><HEAD></HEAD><BODY><P>no, this is not the solution in my case.</P></BODY></HTML> Tue, 22 Oct 2013 15:10:27 GMT https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505493#M481122 2013-10-22T15:10:27Z Re: Problem: Concatenate Tables https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505494#M481123 <HTML><HEAD></HEAD><BODY><P>Hi Mario,</P><P>Could yo try not to concatenate tables, use Join instead so you can have defects and produced values in the same row.</P></BODY></HTML> Tue, 22 Oct 2013 15:13:03 GMT https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505494#M481123 2013-10-22T15:13:03Z Re: Problem: Concatenate Tables https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505495#M481124 <HTML><HEAD></HEAD><BODY><P>please fund attahment</P><P>hope it heps u..</P><P>u have to join</P></BODY></HTML> Tue, 22 Oct 2013 15:48:09 GMT https://community.qlik.com/t5/QlikView/Problem-Concatenate-Tables/m-p/505495#M481124 preminqlik 2013-10-22T15:48:09Z