Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Link the tables

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

2 Replies
ychaitanya
Creator III
Creator III

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

PrashantSangle

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂