3 Replies Latest reply: Sep 10, 2017 6:14 PM by Pablo Labbe RSS

    Tag Country as Map

    Eleyeh Abaneh

      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,

        • Re: Tag Country as Map
          Pablo Labbe

          France is the only country ?

            • Re: Tag Country as Map
              Eleyeh Abaneh

              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))

            • Re: Tag Country as Map
              Pablo Labbe

              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)