# New to Qlik Sense

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

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for
Did you mean:
Employee

## Custom grouping in QlikSense

Hi - how do I create a custom group dynamically in QlikSense? For e.g. I have 5 countries in my Geography hierarchy USA,Canada,Mexico,Argentina and Brazil. In my dashboard I only want to see North America(USA,Canada,Mexico) and South America(Argentina and Brazil). Any ideas?

1 Solution

Accepted Solutions

You could use a calculated dimension as a quick and dirty solution:

=If (Match(Country,'USA', 'Canada', 'Mexico'), 'North America',

If(Match(Country, 'Argentina', 'Brazil'), 'South America))

But a better solution is to create a mapping table to load the group as a derived field in the load script.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies
Specialist

Refer this doc.. this might helps!

grouping dimension values

Sreeni

You could use a calculated dimension as a quick and dirty solution:

=If (Match(Country,'USA', 'Canada', 'Mexico'), 'North America',

If(Match(Country, 'Argentina', 'Brazil'), 'South America))

But a better solution is to create a mapping table to load the group as a derived field in the load script.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Map_Group:

[

Country, Group

USA, North America

Mexico, North America

Argentina, South America

Brasil, South America

];

Country,

ApplyMap('Map_Group', Country, 'Other') As CountryGroup,

...

Now use CountryGroup as the first dimension in your pivot and/or add a list box for CountryGroup to your dashboard.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Employee
Author

Thank you for the answers above. Based on the suggestions above I created a test app and it's uploaded if you need to use it for a demo or as a starting point.

Tags
Community Browser