Link the tables

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

Hi All,

I have loaded following fields from one qvd say T1: i.e.

T1:

Sales_Organization,

Product_Group,

month(TecoProxy) as TecoProxy ,

TecoProxy_Year,

Cat,

Consumption,

SWO_Count

Now i loaded one more table with the following fields:

T2:

Sales_Organization,

Product_Group,

[Norm Applicable Year] ,

Cat,

Consumption,

SWO_Count,

NORM

Now in second table i need only Norm to be in first table and i don't want Sales_Organization,Product_Group,[Norm Applicable Year] ,Cat,Consumption, SWO_Count from second table.

Norm is derived from based on year and it is not derived based on Month but when i add TecoProxy from first table in dimension then i am getting values for Norm for all the months which is wrong because since i don't have Norm at month level i need to get same values in chart. But instead of that i am getting different vales for month

Can you please help me how can we achieve it.

Attached app for more reference

Thanks,

Bharat

Re: Link the tables

ychaitanya — Tue, 13 Feb 2018 14:12:26 GMT

Can you use Lookup() function rather than join to avoid those entries ?

Re: Link the tables

PrashantSangle — Tue, 13 Feb 2018 14:26:07 GMT

what is your expected output, w.r.t. sample data which you provided??

Regards

topic Link the tables in QlikView

Link the tables

Re: Link the tables

Re: Link the tables