Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
gupta_n8
Specialist II
Specialist II

Macro to get address from latitude and longitude

Hi All,

I am having having a list of Latitude and longitude based on some dimension.

What I want now is to have the address, City, State, Country, Zip Code for all of these latitude and longitudes.

Please help me in crating a Macro which will read all the latitude and longitude from the application and return back the address, sity, state and country which I can use for further dashboard requirements.

Regards

Nitin

10 Replies
jmvilaplanap
Specialist
Specialist

Hi

I published a excel macro to do it, you can see it in: Address2Coord.xlsm

I think is better than create the macro directly in QV because the 2000 get restriction.

Regards

jmvilaplanap
Specialist
Specialist

Ups, is the opposite that you need.

Sorry!

jmvilaplanap
Specialist
Specialist

gupta_n8
Specialist II
Specialist II
Author

Hi ,

Thanks for the help,

Can you help me out with the reverse also.

As I am totally new to Excel macros scripting.....

Regards

Nitin Gupta

gupta_n8
Specialist II
Specialist II
Author

Hi Jose,

If you implement it , please do send me the script, so that it will be helpful to me also.

Thanks

jmvilaplanap
Specialist
Specialist

Hi, I was taking a look on yesterday, but this webservice is only for US addresses...

If you find a webservice available for the whole world, please tell me and we try to implement it.

Thanks.

gupta_n8
Specialist II
Specialist II
Author

I need only for US, Canada and mexico.

gupta_n8
Specialist II
Specialist II
Author

I have a html which takes lat long as input and gives the address in alert popup.

Its using googleapis in jScript.

Hope it can help you

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

    <title></title>

</head>

<body>

    Latitude:

    <input type="text" id="txtLatitude" value="18.92488028662047" />

    Latitude:

    <input type="text" id="txtLongitude" value="72.8232192993164" />

    <input type="button" value="Get Address" onclick="GetAddress()" />

    <script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false"></script>

    <script type="text/javascript">

        function GetAddress() {

            var lat = parseFloat(document.getElementById("txtLatitude").value);

            var lng = parseFloat(document.getElementById("txtLongitude").value);

            var latlng = new google.maps.LatLng(lat, lng);

            var geocoder = geocoder = new google.maps.Geocoder();

            geocoder.geocode({ 'latLng': latlng }, function (results, status) {

                if (status == google.maps.GeocoderStatus.OK) {

                    if (results[1]) {

                      alert("Location: " + results[1].formatted_address);

                    }

                }

            });

        }

    </script>

</body>

</html>

Anil_Babu_Samineni

With in the JS i didn't seen any popup Tags? Can you high light those if possible

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)