Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Honored Contributor III

Re: How to add custom category fields?

Use Apply Map command.

Vikas

Not applicable

Re: How to add custom category fields?

Could you please elaborate more on this?

Thanks for the help!

Srijhari

vikasmahajan
Honored Contributor III

Re: How to add custom category fields?

PFA sample.

Vikas

vikasmahajan
Honored Contributor III

Re: How to add custom category fields?

PFA sample.

Vikas

Not applicable

Re: How to add custom category fields?

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
Esteemed Contributor

Re: How to add custom category fields?

Just search for Mapping in the Qlik Sense help!

Andy

Employee
Employee

Re: How to add custom category fields?

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

Re: How to add custom category fields?

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