Tag Country as Map

[#1]

Hi,

I am very new to Qlik and working on Qlik Sense.

I load data from a database. The data I load are prices data by country but since there's is no field describing the country in my database, I added them manually in my load editor. Now, I want to tag this new country field as a Map field to use a Map chart.

Here's a piece of my code :

LOAD date,

  'France' as country,

  [price] as FR_prices;

[FR_prices]:

SELECT "date",

  "price"

FROM "public"."FR_prices";

Do you know a way to help Qlik recognise France as a country area to use a Map chart ? I am unfortunately not able to go to the data manager and synchronise my tables. I must work on the load editor.

Best regards,

[pablolabbe]

France is the only country ?

[#3]

I also have Belgium, Germany and Netherlands.

For Belgium :

LOAD date,

  'Belgium' as country,

  [price] as BE_prices;

[BE_prices]:

SELECT "date",

  "price"

FROM "public"."BE_prices";

and the same structure for Germany and Netherlands (where BE is substituted by DE and NL). I also have a synthetic key issue with date and country but I'm not sure if it is related (and I still hope to manage to fix this by myself (even though any suggestion is warmly welcomed))

[pablolabbe · Accepted solution]

Follow these steps to

Create a spreadsheet with just 1 column.

Write country in the first row.

From the second row, write down the countries you wish to plot in the map.

- Save the spreadsheet and use data manager to import the file.

- Pepare the data

- Import the File

- Goto the app overview and open a sheet

- Create a map object and add a dimension. You will see country as a dimension to pick.

Your script will have sections managed by you (unlocked), and one managed by data manager (locked)