Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

izzatazfar8
New Contributor II

Add another association

Hi I have a 2 files and it has 2 fields that same for project and date. I asscociate project but when i do for date, the project association went missing. Please help me

5 Replies
ali_hijazi
Honored Contributor

Re: Add another association

I just looked into your file (.qvf)

you are using the Data Manager and not the script editor

in the Schema I found that the two tables are related via the common field "Date Combined"

now if you want to link the two tables via the 2 columns Project and Date Combined, then both tables should have the same field name for the project

but keep in mind that when two tables have more than one column in common then synthetic keys will be created and this is not recommended in qlik so you have to create composite key in both tables like Project & '|' & DateCombined as key

shraddha_g
Honored Contributor III

Re: Add another association

You can associate both Tables by using Composite Key,

Project &'-'& Date as Key

izzatazfar8
New Contributor II

Re: Add another association

How to create composite key? Using script editor or what. Can you give me step by step. Thank you

shraddha_g
Honored Contributor III

Re: Add another association

ali_hijazi
Honored Contributor

Re: Add another association

yes in the Load Script

load Field1 & '|' & Field2 as Key

Community Browser