topic Re: Help Needed in QlikView

Help Needed

Mon, 18 Nov 2013 06:33:50 GMT

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.

Mon, 18 Nov 2013 08:24:05 GMT

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