Help Needed

[#1]

Hi All,

I have data for the following countries I want them to be grouped under another field called Regions.

I have these mappings in an excel

Regions      APAC    EUROPE    IMEA           AMERICAS

Country          

               Australia    Albania    Afghanistan    Antigua

              Bhutan        Armenia    Algeria       Argentina

               Brunei        Austria    Angola            Aruba

               Brunei    Azerbaijan    Bahrain          Barbados

At present there is no field called Regions.But I want to map these countries and few more according to the regions.

How can this be achieved in Qlikview?What is the function or method need to be used for this?

Your help is greatly appreciated

Thanks in advance.

[#2]

Hi,

   You can also map in excel itself like this:

1. Create one Table for Regions with unique id.

2. Create another table for country and add one more column (same as unique column id  in Region table ).

example:

Region:

ID, Region

1, APAC   

2, EUROPE   

3, IMEA          

4, AMERICAS

Country:

ID, Country

1, Australia   

1, Bhutan       

2, Armenia   

3, Afghanistan   

3, Algeria      

4, Antigua

I hope this will help you

Regards,

Ashutosh