topic Re: Linking fields in QlikView

Linking fields

Fri, 15 Feb 2013 15:53:51 GMT

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!

Re: Linking fields

Gabriel — Fri, 15 Feb 2013 20:16:00 GMT

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

Re: Linking fields

Anonymous — Fri, 15 Feb 2013 20:56:31 GMT

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

Re: Linking fields

Tue, 19 Feb 2013 13:40:51 GMT

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!

Re: Linking fields

Anonymous — Tue, 19 Feb 2013 14:49:35 GMT

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.

Re: Linking fields

Tue, 19 Feb 2013 15:56:37 GMT

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