I have two tables: Table1 and Table2. I have 4 fields in my Table2, and 21 fields in Table1.
I want to link the two tables based on a field that exist in Table2 and should be derived for records in Table1. I was able to do so by doing the following and it works. So the intention of the following is to derive the new field and add it to the Table1.
Field1 & ' ' & Field2 as NewField,
Drop table TestTable;
So now my Table1 has 21 fields including the NewField.
Qlikview is now linking Table1 and Table 2 by the NewField.
The counts of values in NewField is different between the two tables. When I do the counts (to plot in pie charts, etc.) it counts NewField in Table2, and not Table1. I want to be able to perform the count on NewField in Table1. How can I do it?