This content has been marked as final. Show 4 replies
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.