Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Modify assocition manually

Hi Experts,

I need to associates two tables based on field whcih is different from the recommended association. (Qliksense desktop 3.1)

When I break assocaition no option to set custom association. If I make custom association, recomended association is still there. Also custom association is coming in red colour .

Can some suggest if I am apoting wrong method to define association.

Thanks

Parul

7 Replies
bellamae
Valued Contributor

Re: Modify assocition manually

To associate two fields they need to be named the same so you need to rename the one currently associating so they are different and then rename the fields you want to associate so they are the same.

chooco_co
Valued Contributor

Re: Modify assocition manually

Hi Parul,

You can do manually by using script on data load editor but you need to learn scripting.

If you use scripting then Qlik only knows associative by using the same field/column name.

Regards,

Marco

lakshmikandh
Valued Contributor II

Re: Modify assocition manually

also have a look at this if this helps

Understanding Join, Keep and Concatenate

Not applicable

Re: Modify assocition manually

I am using quik data load option for making dashbaords. Directly from oracle tables . I have not inserted the script yet. Am I taking wrong path

chooco_co
Valued Contributor

Re: Modify assocition manually

Hi Parul,

as default when you're using quick data load, Qlik always generate script and you can edit manually.

Please check this video.

https://www.youtube.com/watch?v=H-Xj92Nerz8

Hope this help

Regards,

Marco

Not applicable

Re: Modify assocition manually

Hi Marco,

I am using QS desktop 3.1 only . While selecting oracle tables > LOad data . below are the screen. However dataload editor has only default scirpt.data model viewer.PNG

data load editor.PNG

chooco_co
Valued Contributor

Re: Modify assocition manually

Hi Parul,

Check tab on your left and you will see auto-generated section.

Choose that tab and unlock after that you can edit the script but after you unlock the script, you won't be able too see bubble view again.

You can check your data model on data model viewer.

Regards,

Marco