Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

laylagirl
New 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
Employee
Employee

Re: How to resolve non existing dimension ?

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

laylagirl
New Contributor III

Re: How to resolve non existing dimension ?

No

Employee
Employee

Re: How to resolve non existing dimension ?

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

Re: How to resolve non existing dimension ?

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

-Rob

laylagirl
New Contributor III

Re: How to resolve non existing dimension ?

Hi Rob,

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

While table 2 only has names of city + county.

Re: How to resolve non existing dimension ?

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

Re: How to resolve non existing dimension ?

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.