Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
Specialist
Specialist

Ups, is the opposite that you need.

Sorry!

Highlighted
Specialist
Specialist

Highlighted
Specialist II
Specialist II

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

Highlighted
Specialist II
Specialist II

Hi Jose,

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

Thanks

Highlighted
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.

Highlighted
Specialist II
Specialist II

I need only for US, Canada and mexico.

Highlighted
Specialist II
Specialist II

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>

Highlighted

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)