2 Replies Latest reply: Feb 4, 2016 2:00 PM by ddd ddd RSS

    Problem with GEOMakepoint

    ddd ddd

      I am unable to make the assembly of my map QlikSense

       

       

      below my script

       

      [jan_2016]:

      LOAD [ano],

        [num_rel],

        [local],

        [data_rel],

        [setor],

        [tipo_atual],

        [tipo],

        [nome_prop_empreend],

        [end_empreend],

        [cid_empreend],

        [data_ini],

        [fase],

        [quantificacao],

        [nome_rt_princ],

        [cart_rt_princ],

        [nom_fisc],

        [situacao],

        [cidade],

        [hyperlink],

        [num_art_princ],

        [data_art_princ],

        [fase_atual],

        [alvara_mun]

      FROM [lib://Desktop/jan_2016.txt]

      (txt, utf8, embedded labels, delimiter is ';', msq);

       

       

      [Planilha1]:

      LOAD [num_rel],

        [Latitude],

           [Longitude],

           GeoMakePoint(num(Latitude,'##,#######'),num(Longitude,'##,#######')) as location

      FROM [lib://Desktop/latlog.xlsx]

      (ooxml, embedded labels, table is Planilha1);

        • Re: Problem with GEOMakepoint
          Rohan DSouza

          Hi,

           

          Try creating a new Dimension in your Master Items having field defined as GeoMakePoint(Latitude,Longitude) and give it a name 'GeoKey' (any name would do).

          Once you are done with it, drag the map chart into your sheet and add 'GeoKey' as your dimension.

          Example:

          GeoMakePoint.png

           

          Regards,

          Rohan