Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
laylagirl
Contributor III
Contributor III

How to resolve non existing dimension ?

Hello ,

What is the best way to connect a dimension missing in a table ?

LOAD:

Region

Year

Month

Sales

from Table1

LOAD

Channel

City

Country

Order

from Table2

Requirement is  sum of Orders from Table2 must reflect by Region in Table1.

7 Replies
Clever_Anjos
Employee
Employee

Do you have any table that links Regions to Channel/City?

laylagirl
Contributor III
Contributor III
Author

No

Clever_Anjos
Employee
Employee

I don´t see how we could link those tables if you don´t have a possible key to match records from one table to another

rwunderlich
Luminary Alumni
Luminary Alumni

Do you have data that identifies what City & Country belong to which Region?

-Rob

laylagirl
Contributor III
Contributor III
Author

Hi Rob,

Regions are only defined in table 1 as   APAC, EMEA, LATAM, NA

While table 2 only has names of city + county.

rwunderlich
Luminary Alumni
Luminary Alumni

So how would you know which rows of Table2 belong to which region?  To resolve this, you will have to create a table that associates Countries to Regions.

-Rob

bill_markham

If you have not got the region vs. country look up data then you could probably download something from the web.  A quick search found this https://docs.adjust.com/en/countries-by-region/

Obviously it depends on the exact formats you have for Country and Region in your data.