Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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
Partner
Partner

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
Specialist II
Specialist II

also have a look at this if this helps

Understanding Join, Keep and Concatenate

Not applicable
Author

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
Partner
Partner

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
Author

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
Partner
Partner

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