Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking fields

Hi -

I have two tables that i need to link as part of my pie chart.

I was able to link these fields in a straight table using IF formula and now I am having hard time linking straight table values to pie chart for TAGS.

=if(left([issueID],3)='ABC',('Testing'),[tags])

Table 1

Issue ID| Description| Tags|

Table 2

Issue ID| Description

Please help!

5 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

I would just JOIN the two table together.

JOIN has variation with it, LEFT JOIN, RIGHT JOIN, INNER JOIN. Please note, using just JOIN with result in OUTER JOIN. So use approriate JOIN.

Regards,

Gabriel

Anonymous
Not applicable
Author

Are you trying to get all records from Table 2 and only the tags from Table 1?  You will want to create the "link" or the join in your load script.

Sample below will return all results for the Issue IDs

'Table 1':

Load * inline

[

          Issue ID, Description,   Tags

          1,   Desc1,  Tags1

          2,   Desc2,  Tags2

          3,   Desc3,  Tags3

];

'Table 2':

OUTER JOIN

load * inline

[

          Issue ID, Description

          1,   Desc_Table2_1

          2,   Desc_Table2_2

];

Issue ID Tags Description
1 Tags1 Desc1
1
Desc_Table2_1
2 Tags2 Desc2
2
Desc_Table2_2
3 Tags3 Desc3
Not applicable
Author

Hi Nick,

I am trying to create a link between 2 tables and combine all of the records, not only tags. What would be the best way to do this in a formula?

Thank you!

Anonymous
Not applicable
Author

do you have sample data or able to provide your table designs?

If both tables share the same unique ID column name, the join method will automatically link the fields and the fields in both tables will be available.

Not applicable
Author

Both tables do not share the same unique ids'. The only thing that is shared is the table name. Does that help?