Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad786
Contributor
Contributor

Need help to create more than one association

Hi

I am having my data in 8 different sheets in SQL database. In all these sheet 2 columns ( Date and Node Name) are same in every sheet. I want to create two simultaneous associations 1 for date and 1 for node name so that I can filter  based on selection and all my related output will keep changing based on any of this  filter selection

Can anyone help me

Thank you

Prasad

1 Reply
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Prasad,

Is the data independent on every table or does it have some sort of correlation?

Say, sales and proposal would have keys that are related, so you could have them linked by a common key (let's say [Node Name] and [Date]) and make all the associations follow the same rule.

Or they could be excludent, say HR info and Sales Orders, and for that case you could create a linktable with the concatenated fields from each table do denote each information individually.

Additionally, since you have them linked by the key, you would be able to take those fields of the individual tables, so that only a central table contains all the possible variations.