Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

kiranjay
New Contributor III

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

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.

6 Replies
YoussefBelloum
Esteemed Contributor

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

Hi,

What is the structure of your table ?

to be able to drill down, you should have: Country, cityname, Long lat

kiranjay
New Contributor III

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

its 2 seperate table. City name comes in excel and Inline table for Lat Long Values.

As far as I know we should create a Drill Down Group with Latt Long & City Name and use it as Dimension in the Chart layer.

But creating a Drill down group is not working with different data set.

YoussefBelloum
Esteemed Contributor

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

you should at least link (join) the tables ! otherwise the drill down will not work.

did you join the tables ?

kiranjay
New Contributor III

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

Yeah thats is done. ID field is the link between 2 table

YoussefBelloum
Esteemed Contributor

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

Try to use this drill down group on a simple table to see if it is working well.

if it don't work, try to attach sample app (QVF) with these 2 geo-tables

kiranjay
New Contributor III

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

forget Different composition of datas in Drill down.

Is it possible to use "Long Latt" data of State and "Long Latt" data of city in a drill down chart layer?

Community Browser