2 Replies Latest reply: Mar 15, 2018 4:59 AM by Youssef Belloum RSS

    Maps in qlik sense

    Pasquale Cosimato

      Good morning

      I m learning about use of Maps in qlik sense.

      I load simple data with this code:

       

      [Mapdata]:

      Load

      [Company] AS c,

      CountryName,

      CountryCode,

      Number,

      Latitude,

      Longitude,

      GeoMakePoint(Latitude,Longitude) as Location

      FROM [lib://../MapsDataTest.xlsx]

      (ooxml, embedded labels, table is Sheet1)

      ;

      Trace ***** SkriptEnde *****;

      Exit Script;

       

      Now of course the result that I have is with Point but I would have different color for the country based on the sum(Numner). see the picture attached.

       

      I have maybe to load the data in different way, someone have a suggestion?

       

      Thanks for any helps