How to differentiate one Key Associated column from two different tables
Hello, everyone! I am pretty new in Qlik Sense and I trying to solve one problem regarding associations. I have two different tables, with a Key connection (association) in column "Xnumber" between the two. However, this column in Table1 has a bigger amount of data compared to Table2. I want to create objects/graphs with measures in which I can deal with just the values from one of these tables. Since all the data from Table 1 is included in Table 2 (but not the opposite), I want to create objects that return only the data from "Table2.Xnumber", and not the values presented in Table1.Xnumber. In summary, I want to create measures where I can differentiate the data from the key association of both tables (since the values are not 100% the same) while maintaining the association.
Is that possible? What can I do? I thought about using this format "Table.Key", but I am looking for an alternative only coding via Data Load Editor.
Thank you for the help! But how can I use set analysis and see all the values without using aggregation functions like 'Sum' that you used? I want to create an object where I will be able to see only the values from "HasTable2XNumber', but with the exactly data from the table, with no aggregation function.