topic How to differentiate one Key Associated column from two different tables in App Development

How to differentiate one Key Associated column from two different tables

Polor1993 — Fri, 03 Jun 2022 19:11:27 GMT

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.

Re: How to differentiate one Key Associated column from two different tables

chrismarlow — Sat, 04 Jun 2022 13:12:58 GMT

Hi,

Some objects will cope with this anyway (if you take off 'Include zero values'). But you can add a flag to the table with less data in, so something like this;

Table1: Load * Inline [ XNumber, A 1, 10 2, 15 3, 20 ]; Table2: Load *, 1 AS HasTable2XNumber; Load * Inline [ XNumber, B 1, 5 3, 25 ];

Then use set analysis, similar to bottom right here;

Cheers,

Chris.

Re: How to differentiate one Key Associated column from two different tables

vinieme12 — Sun, 05 Jun 2022 05:27:09 GMT

Simply load the column two times in each table

Example

Table1:

Load Keyfield //this field links to table2

Keyfield as Keyfield1 // this one does not link to table1

Otherfields

From sourcetable1;

Table2:

Load Keyfield //this field links to table1

Keyfield as Keyfield2 // this one does not link to table1

Otherfields

From sourcetable2;

Then use keyfield1and Keyfield2 in charts

Re: How to differentiate one Key Associated column from two different tables

Polor1993 — Fri, 01 Jul 2022 20:24:50 GMT

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.