4 Replies Latest reply: Oct 22, 2013 11:48 AM by Prem Kumar Thangallapally RSS

    Problem: Concatenate Tables

    Mario Hölzer

      Hello Community,

       

      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.

       

      Thank you!