topic Re: Joining two tables in QlikView

Joining two tables

billuran — Tue, 18 Jul 2017 22:16:13 GMT

Hello, I ave joining problem, I have two tables as stated below example:

Table 1: Data Table

Table 2: Target Table

I need to associate each target with the above table, based on dept and PayPeriod.

I want o to be able always want to see the amount no matter what the target selected.

Here is is the structure i want: Would like 45 to populated all the way down, this is where i am struggling.

aarkay29 — Wed, 19 Jul 2017 01:29:18 GMT

Try

sum(Total<Dept>Amount) as Expression

arvind_patil — Wed, 19 Jul 2017 03:03:18 GMT

Hi Bill,

Join Both Tables With the help of Key like below:

DEPT&'-'&[PAY PERIOD] as %KEY

And remove those field from second table

Thanks,

Arvind Patil

Kushal_Chawda — Wed, 19 Jul 2017 07:14:47 GMT

see this

TargetMap:

mapping LOAD

Dept&[Pay Period] as Key,

Target

FROM table2;

Table1:

LOAD Dept,

Amount,

[Pay Period],

applymap('TargetMap',Dept&[Pay Period],0) as Target

FROM table1;