4 Replies Latest reply: May 12, 2016 3:31 PM by Tom Donahue RSS

    Map with Alaska & Hawaii?

    Tom Donahue

      Hello - I am new to Qlik Sense and trying to create a map with Alaska and Hawaii adjacent to the continental U.S. Any suggestions on how to do this? Thanks.

        • Re: Map with Alaska & Hawaii?
          Michael Tarallo

          Hello Tom - here is the sample I promised as per your comment in the video.

           

           

           

          You do this by loading different parts of the XML file using a WHERE condition as in:

           

           

          [MAIN_LAND]:
          LOAD
              [US States.Name] AS [STATE],
              [US States.Area] AS [US States.Area];
          LOAD
          [US States.Name],
          [US States.Area]
          FROM [lib://Map_data_and_kml/US States.kml]
          (kml, Table is [US-States.shp/Features])
          WHERE [US States.Name] <> 'HI' AND [US States.Name] <> 'AK'
          ;
          
          [Alaska]:
          LOAD
          [US States.Name] AS [STATE],
          [US States.Area] AS [US ALStates.Area];
          LOAD
          [US States.Name],
          [US States.Area]
          FROM [lib://Map_data_and_kml/US States.kml]
          (kml, Table is [US-States.shp/Features])
          WHERE [US States.Name] = 'AK'
          ;
          
          [Hawaii]:
          LOAD
          [US States.Name] AS [STATE],
          [US States.Area] AS [US HIStates.Area];
          LOAD
          [US States.Name],
          [US States.Area]
          FROM [lib://Map_data_and_kml/US States.kml]
          (kml, Table is [US-States.shp/Features])
          WHERE [US States.Name] = 'HI'
          ;
          
          

           

           

          Let us know how you do.

           

          Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

           

          Regards,

          Mike Tarallo

          Qlik

          • Re: Map with Alaska & Hawaii?
            Michael Tarallo

            By the way, I see you stated you are new to Qlik Sense, but I did see your comment on the creating a polygon map video, so I assume you got that part down ok, if not let me know. I also attached the sample data and kml file to this post.

             

            Mike