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 :
'France' as country,
[price] as 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.
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))