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?
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?
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.
ApplyMap('map', country_Name, 'Other') as 'All Countries'