Creating a dimension with specific values from another dimension? (Como criar uma dimensão com valores específicos de outra dimensão?)

[#1]

Good afternoon,

I'm new in QlikView and my question is relatively simple.

Imagining that I have a dimension with several countries, I would like to create a new dimension by selecting only the countries of South America for example:

Field Countries: Brazil, Germany, Italy, Mexico, Spain, Switzerland, Uruguay, Colombia, Portugal, USA, Venezuela, Argentina, Costa Rica, Peru, Ireland, France, Canada, Netherlands.

New South American country: Brazil, Uruguay, Colombia, Venezuela, Argentina, Costa Rica, Peru.

The goal is to create a graph that shows the information only from South American countries, not all countries in the original size.

Thank you for your help.

Rodrigo Caldas

Translated with Google Translate - Qlik Community Administrative Team

Boa tarde,

Sou novo no QlikView e minha dúvida é relativamente simples.

Imaginando que eu tenho uma dimensão com diversos países, eu gostaria de criar uma nova dimensão selecionando apenas os países da América do Sul por exemplo:

Campo Países: Brasil, Alemanha, Italia, Mexico, Espanha, Suiça, Uruguai, Colombia, Portugal, USA, Venezuela, Argentina, Costa Rica, Peru, Irlanda, França, Canada, Holanda.

Novo campo América do Sul: Brasil, Uruguai, Colombia, Venezuela, Argentina, Costa Rica, Peru.

O objetivo é criar um gráfico que mostre as informações somente dos países da América do Sul, e não todos os países da dimensão original.

Obrigado pela ajuda.

Rodrigo Caldas

[julian_rodriguez · Accepted solution]

Hello Rodrigo

You can do it with a inline table to create the new dimension, on this case I will name it "Continente":

Pais_Continente:

LOAD * INLINE [

    Países, Continente

    Colombia, Sur America

    Brasil, Sur America

    Mexico, Centro America

    USA, Norte America  

];

If the original name is [Países], the associative technology of Qlikview will do the job.

Regards

[yura_ratu]

Hi Rodrigo,

You need to create expression kind of

sum( {<Continent={'South America'}>} FiledName )

and pick 'Suppress when value is null' in dimension properties.

Search community for Set analysis for more info

[Peter_Cammaert]

I guess it wouldn't be that difficult to locate a table like that for all countries on the internet and include it in an INLINE LOAD just like Julian suggested. Continent membership is a pretty stable quality these days

See for example: Countries Listed by Continents - Worldatlas.com

Peter

[#5]

Thans Julian foy your help.

Yout tip solve my problem.

Regards

[Kushal_Chawda]

Create Calculated dimension as

=if( match(YourCountryField, 'Brazil', 'Uruguay', 'Colombia', 'Venezuela', 'Argentina', 'Costa Rica', 'Peru'),YourCountryField)

and check 'Suppress when value is null' for this Calculated dimension

Give label to this Field as South America

[julian_rodriguez]

You are welcome!