Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add custom category fields?

Hello,

Suppose I have a dimension which is Country_Name and I want to create a new category which says All_Countries which is a grouping of all the country names so that I can show a single value for my measures. How do I do this using Qlik Sense?

Thanks,

Srijhari

8 Replies
vikasmahajan

Use Apply Map command.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Could you please elaborate more on this?

Thanks for the help!

Srijhari

vikasmahajan

PFA sample.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan

PFA sample.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

I am working on Qlik Sense. Could you attach a .qvf file or a snapshot of the code please?

Sorry for the trouble!

Thanks

awhitfield
Partner - Champion
Partner - Champion

Just search for Mapping in the Qlik Sense help!

Andy

Anonymous
Not applicable
Author

Hi,

What are you trying to achieve? From the Filter Pane you can select all countries to select all. If you have a table the total row shows the value for all countries.

Are you trying to group countries by say a Region? I.e. Europe, North America, Australasia etc?

Not applicable
Author

I am trying to use the field All_Countries in a bar chart, to show the Current Sale vs. Total New Sale. I've tried using the Apply Map function, but the chart shows null values. How do I resolve this?

Please find the attachment below.

This is the following piece of code that I used.

all_countries:

Load*,

ApplyMap('map', country_Name, 'Other') as 'All Countries'

resident map;

Thanks!

image1.png