Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
prashantsharma8837
Contributor
Contributor

linking two tables with multiple

Dear All,

I have two table one have (First Table) ZONE , REGION & TERRITORY. Another (Second Table) table have ZONE, REGION , TERRITORY , TYPE & VALUE.

WHY Zone & Region in Second Table :- Zonal Manager & Regional Manager fill their expenses & ID stores in ZoneID & RegionID in Second Tabel with FLAG (TYPE)

Problem :- If links the table with TerritoryID , wherever Zonal & Regional Managers enter their data & ID get stored individually, Hence TerritoryID is null at the places & data is cannot be mapped.

Customer Requirement : - Link both table with territory & get the output for Zonal Manager & Regional Mangers Value.

Attaching the Excel Data. Please Help

Thanks in Advance

 

 

Labels (2)
2 Replies
Mark_Little
Luminary
Luminary

Hi.

At a quick glance i would look at splitting the second table into the tables.

Load 

ZoneID,

Type as Zone_Type,

Value as Zone_Value

Resident Table1

Where LEN(ZoneID) > 0;

 

repeat for the other IDs

 

prashantsharma8837
Contributor
Contributor
Author

Hey mark,

Thanks for the solution, but i don't think that i can plot all three table into a single pivot with a single value field.