topic Re: How to use 2 fields from different tables as dimensions in QlikView

How to use 2 fields from different tables as dimensions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I've got two tables that each have a field I want in a report that I'm building.

- Table 1

Field - Job Description

- Table 2

Field - Job Number

I'm trying to build a report that shows the job number and then the job description. All of the data in my expressions comes from Table 2. I'm looking for a way to be able to show the Job description as well. Table 1 also has a field with the Job number in it.

Any help would be appreciated. Thanks.

Re: How to use 2 fields from different tables as dimensions

vishsaggi — Fri, 22 Jun 2018 21:22:06 GMT

Are your both tables linked? Can you show your data model?

Re: How to use 2 fields from different tables as dimensions

Anonymous — Mon, 25 Jun 2018 12:10:00 GMT

The tables are not linked but they share a common field with a different name. I need to link Item code to Cost Job code so that I can use Item description.

Re: How to use 2 fields from different tables as dimensions

vishsaggi — Mon, 25 Jun 2018 19:11:13 GMT

Just rename your Item Code to Cost Job Code in your Item table. Like below and reload your script;

LOAD %ItemKey,

[Item Unit Code],

[Item Code] AS [Cost Job Code],

[Item Description]

From SourceTableName;

Re: How to use 2 fields from different tables as dimensions

ruanhaese — Tue, 26 Jun 2018 10:18:23 GMT

If you dont link the tables what will happen is that Qlik makes a cartesian plane

from the data and multiply every value out when you try and connect them.

As Vishwarath said you can link them by simply changing the fieldname and let Qlik auto-associate

Re: How to use 2 fields from different tables as dimensions

Anonymous — Fri, 29 Jun 2018 14:21:38 GMT

Thanks for the help. Before I try this I have one more question. I've never dealt with the script editor up until this point. When I do this I won't affect other current objects that use the tables as they are today right? Thanks again.