topic Re: Map For one country with cites in QlikView

Map For one country with cites

jood_ahmad — Fri, 13 Apr 2018 09:33:47 GMT

Hi Experts,

This is urgent please,

I'm in a project and one of the requirements is to build a sales map for Saudi Arabia only related to sales on Qlikview and i tied my best to build a map but failed so can anyone help on this, please.

Cuntry, City , Sales

Saudi Arabia , Riyadh, 4000

Saudi Arabia, Jeddah, 3000

exc.

stevedark‌rwunderlich

Re: Map For one country with cites

YoussefBelloum — Fri, 13 Apr 2018 10:02:31 GMT

Hi,

read this:

https://community.qlik.com/docs/DOC-9561

Re: Map For one country with cites

jood_ahmad — Fri, 13 Apr 2018 10:07:55 GMT

Hi,

The issue is i don't have location numbers for the area

Re: Map For one country with cites

YoussefBelloum — Fri, 13 Apr 2018 10:16:28 GMT

you can easily find it using google maps, like this:

so here, latitude and longitude for RIYADH is:

latitude: 24.7241503

longitude: 46.2620456

Re: Map For one country with cites

stevedark — Fri, 13 Apr 2018 11:36:07 GMT

How many locations do you have to look up the lat and long for? Up to a certain number of cities finding the locations will be best done manually, as youssefbelloum‌ suggests. If you have many locations you may want to look at using the Google Maps Geocoding API to pull the locations.

Steve

Re: Map For one country with cites

YoussefBelloum — Fri, 13 Apr 2018 11:42:22 GMT

Yes, i created many scripts before that fetch the coordinates from the google API with looping on the list of adresses. But they have put limits if you loop with a huge list of adresses, so you will need to sleep the script, use differents api Keys etc

Re: Map For one country with cites

YoussefBelloum — Fri, 13 Apr 2018 11:52:23 GMT

And it makes sense when I see that the most of Geo coding services are paid services or offered inside paid tools,GeoQlik for example

Re: Map For one country with cites

stevedark — Fri, 13 Apr 2018 12:27:35 GMT

The way to go is to do it incrementally, saving after each location to QVD. When the API runs out the script will bail out (using ERRORMODE and trapping for the error is useful here). If each time you just get locations of cities you don't know where they are yet after a number of runs it will find everything - and the script will be ready for when a new city appears in your data.

The trick is to ensure you only ask for each city once, at least then it is a finite list.

Re: Map For one country with cites

jood_ahmad — Fri, 13 Apr 2018 12:34:21 GMT

Actually, I'm Not good in Maps many time i tried to create it but nothing work.

Re: Map For one country with cites

jood_ahmad — Fri, 13 Apr 2018 12:35:29 GMT

If you guys can guide me in this i will be more than happy.

Re: Map For one country with cites

YoussefBelloum — Fri, 13 Apr 2018 12:42:33 GMT

I've never been asken to fetch a HUGE list of coordinates, I'm always fetching hundreds of adresses maximum, and even with hundreds of addresses, the API blocks me, I've always had to try to get around this limit.

But I think it was because I've run the script multiple time with the same Key (testing and optimizing).. there is also a solution without using a key.. But I've never test it.

Re: Map For one country with cites

YoussefBelloum — Fri, 13 Apr 2018 12:44:41 GMT

I'm talking about this: