6 Replies Latest reply: Dec 13, 2017 12:43 PM by kiran Raj RSS

    Qlik Geo Analytics - Using Lat Long value & city name together in a Drill Down

    kiran Raj

      Hi All,

       

      I am trying to figure out a solution for using Lat Long value and city names together in a drill down option in geo analytics.

       

      Earlier I have tried using state name and city names of a country in drill down option by creating a Drill down group and succeded.

       

      Now I need to use Lat long position of city and  state names in a drill down option. while trying i'm unable to get the appropriate result.

       

      Could any expert help me solve this?

       

       

      Below is the Lat Long value for each state.

       

      LOAD * INLINE [

          Place Name, Lattitude, Longitude, ID

          "Himachal Pradesh, India", 32.084206, 77.571167, 1

          "Telangana, India", 17.123184, 79.208824, 2

          "Madhya Pradesh, India", 23.473324, 77.947998, 3

          "Haryana, India", 29.238478, 76.431885, 4

          "Chhattisgarh, India", 21.295132, 81.828232, 5

          "Haryana, India", 29.065773, 76.040497, 6

          "Bhitarwar, Madhya Pradesh, India", 25.794033, 78.116531, 7

          "Maharastra, India", 19.601194, 75.552979, 8

          "Tripura, India", 23.745127, 91.746826, 9

          "Chandoor, Telangana, India", 17.874857, 78.100815, 10

          "Karnataka, India", 15.317277, 75.713890, 11

          "Kerala, India", 10.850516, 76.271080, 12

          "Uttar Pradesh, India", 28.207609, 79.826660, 13

          "Assam, India", 26.244156, 92.537842, 14

          "Maharashtra, India", 19.663280, 75.300293, 15

          "Tamil Nadu, India", 11.127123, 78.656891, 16

          "Karnataka, India", 15.317277, 75.713890, 17

          "West Bengal, India", 22.978624, 87.747803, 18

          "Gujarat, India", 22.309425, 72.136230, 19

          "Odisha, India", 20.940920, 84.803467, 20

          "Rajasthan, India", 27.391277, 73.432617, 21

      ];

       

      City names are directly from excel.