topic Re: How to use data from two tables in QlikView

How to use data from two tables

Tue, 17 Mar 2015 00:05:13 GMT

Question for everyone. If I have data in one table that contains lets say Total Employee cost as HeadCount and then Monthly Spend in another table called MonthlySpend how can I use each data to calculate monthly spend per employee? Currently if I use them in a chart together I do not receive any results. Do I have to do like a resident load on the script and create the calculate field?

Re: How to use data from two tables

JonnyPoole — Tue, 17 Mar 2015 01:03:23 GMT

Hi Jason , both headcount and monthly spend tables need to have a common key like Employee ID.

If they do, ensure that you alias the matching fields the same way in the load script (ex below)

ex:

Headcount:

load

employee as [Employee ID],

[Total Employee Cost]

from <>;

MonthlySpend:

load

employeeCode as [Employee ID],

[Monthly Spend]

from <>;

Does this help ?

Re: How to use data from two tables

Wed, 18 Mar 2015 17:40:47 GMT

That did help. I actually ended up just doing a preceding load and creating a new table with the data I needed for that one chart.