topic Association not working in App Development

Association not working

Saif1 — Thu, 22 Sep 2022 05:27:48 GMT

Hello guys i have the following scenario :

Employee Table : //Table 1

load

Emp_num as connection key,

Emp_num,

Employee_Name

from .....

Employee performance : //Table 2

load

Emp_num as Connection_key

Emp_num as Performance_employee_key

Emp_Name as Employee_performance_employee_name

Score

from ......

here when i want to put in a table the following fields :

1- Emp_num // from table 1

2- Employee_performance_employee_name // from table 2

it shows eiether the emp num as null on the name as null , why is that ? they are associated via the "connection key"

my understanding for this that if they are associated tables i can mix and match between the tables two fields.

what is happening here ? why i can't use emp number from one table and name from other table, they are associated

Re: Association not working

RsQK — Thu, 22 Sep 2022 05:35:58 GMT

Hi, you need to make sure that the fields you're using as keys are named exactly the same. Try like this:

Employee Table : //Table 1 load Emp_num as connection.#key, Emp_num, Employee_Name from ..... Employee performance : //Table 2 load Emp_num as connection.#key, Emp_num as Performance_employee_key Emp_Name as Employee_performance_employee_name Score from ......

notice how "connection.#key" is named identically in both of the tables - that should be your issue.

Re: Association not working

MayilVahanan — Thu, 22 Sep 2022 06:07:47 GMT

Generally, in Qlik, Associate between the tables are based on "Common" field Name. In your case, 2 tables doesn't have same column name, that's reason, it wouldn't able to associate.

if you see in the table viewer, you can understand, both tables are not associated (no link between tables).

As mentioned by RsQK, you can rename the fields and try it. It will fix auto.

Re: Association not working

Saif1 — Thu, 22 Sep 2022 06:47:33 GMT

Thanks guys for the reply , i made a typo when i was writing the post , they are the same and i have assossiaction in the data model (a link),
My problem is that i have an EMP master table (that has all the employee details num,name, etc)

and i have employee performance table (has emp key , performance numbers)

and when i associate them with the emp key ( i cant name them the same becuase there are multiple table with the same name) so i commoned name them "Connection_Key" , when adding something from the master employee table ( name ,number ,etc ) it gives null in the employee performance fields ( when adding to table) (when using fliters) ets , they are associated but not associated you understamed me ?

Re: Association not working

Saif1 — Thu, 22 Sep 2022 07:11:55 GMT

any solution ?

Re: Association not working

MayilVahanan — Thu, 22 Sep 2022 07:21:30 GMT

Might be, if any one of the table format is different?

Like one table the Empnum is string however another table is num?

or, both has same set of values?

Re: Association not working

Saif1 — Thu, 22 Sep 2022 07:25:53 GMT

how can i check the data type?

Re: Association not working

Saif1 — Thu, 22 Sep 2022 08:28:32 GMT

it worked , i casted all of the emp nums into number and it worked , thanks so much