Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Champion
Champion

Hi,

What is the structure of your table ?

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

Anonymous
Not applicable
Author

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
Champion
Champion

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

did you join the tables ?

Anonymous
Not applicable
Author

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

YoussefBelloum
Champion
Champion

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

Anonymous
Not applicable
Author

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?