Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW

Working with maps from Mapquest

Specialist
Specialist

Working with maps from Mapquest

Hello!

There's an alternative solution to show maps using MapQuest free webservice and maps. To get a key, simply access the site developers.mapquest.com and register yourself.

Labels (2)
Attachments
Comments
Not applicable

I observed that special characters like ö,ü,ä is not read properly when doing the geocoding. All of my duplicate latitude and longitude have special characters in the addresses. Could this be the case? is their a way for mapquest to read special characters? Like for example in google where you could put something like format=utf8.

0 Likes
Specialist
Specialist

Hi Klaus

Put the complete URL in a browser to see the given error, or use the Advanced REST Client in google chrome (via Chrome Store)

0 Likes
Creator II
Creator II

Marcio,

Putting the URL in a browser does not return an error. See below.

<?xml version='1.0' encoding='utf-8'?>

<response>

  <info>

    <statusCode>0</statusCode>

    <messages />

    <copyright>

      <imageUrl>https://api.mqcdn.com/res/mqlogo.gif</imageUrl>

      <imageAltText>&#169; 2014 MapQuest, Inc.</imageAltText>

      <text>&#169; 2014 MapQuest, Inc.</text>

    </copyright>

  </info>

  <results>

    <result>

      <providedLocation>

        <postalCode>30009</postalCode>

        <country>US</country>

      </providedLocation>

      <locations>

        <location>

          <street />

          <adminArea6 type='Neighborhood' />

          <adminArea5 type='City'>Alpharetta</adminArea5>

          <adminArea3 type='State'>GA</adminArea3>

          <adminArea4 type='County'>Fulton County</adminArea4>

          <postalCode>30009</postalCode>

          <adminArea1 type='Country'>US</adminArea1>

          <geocodeQuality>ZIP</geocodeQuality>

          <geocodeQualityCode>Z1XAA</geocodeQualityCode>

          <dragPoint>false</dragPoint>

          <sideOfStreet>N</sideOfStreet>

          <displayLatLng>

            <latLng>

              <lat>34.073519</lat>

              <lng>-84.299945</lng>

            </latLng>

          </displayLatLng>

          <linkId>286279635</linkId>

          <unknownInput />

          <type>s</type>

          <latLng>

            <lat>34.073519</lat>

            <lng>-84.299945</lng>

          </latLng>

          <mapUrl><![CDATA[https://www.mapquestapi.com/staticmap/v4/getmap?key=Fmjtd|luur2568ng,2s=o5-9a1g0r&type=map&size=225,...]]></mapUrl>

        </location>

      </locations>

    </result>

  </results>

  <options>

    <maxResults>-1</maxResults>

    <thumbMaps>true</thumbMaps>

    <ignoreLatLngInput>false</ignoreLatLngInput>

    <boundingBox />

  </options>

</response>

The QlikView script returns the error described above:

The download failed

LOAD

  '30009' as postalCode,

  '100' as CustomerQuantity,

      [results/result/locations/location/mapUrl] as mapUrl,

     [results/result/locations/location/latLng/lat] as latitude,

      [results/result/locations/location/latLng/lng] as longitude

  FROM [https://www.mapquestapi.com/geocoding/v1/address?&key=Fmjtd%7Cluur2568ng%2C2s%3Do5-9a1g0r&inFormat=j...{"location":{"country": "US", "postalCode":"30009"}}&outFormat=xml] (XmlSimple, Table is [response])

0 Likes
Specialist
Specialist

Hi Klaus

I've experienced this kind of issue a few times, and every time I experienced it I identified internet problems.

Unfortunately I can't help you more.

0 Likes
Specialist
Specialist

Hi Marcio

Need your assistance, i get a message 'No data to display', what could be going wrong?  I do not see where the  expression 'Valor' is related to the application.  Please elaborate.

Thanks in advance

0 Likes
Specialist
Specialist

Hi Christopher

I created the expression 'Valor' but you're right, I didn't use it. I fixed a value in third expression of the chart, where I supposed to put 'Valor'.

When I got this kind of message in maps it was usually:

  • Dimension not defined;
  • Expressions latitude and longitude with different names; this is a problema because the formulas use these name to calculate.

If your app still doesn't worlk after this, please send the app so I can look at it.

Márcio.

0 Likes
Specialist
Specialist

Many thanks for your response.  App is now working

0 Likes
MVP & Luminary
MVP & Luminary

Try copying and pasting the URL into a browser - you may find you get a more meaningful error back.  I found that my MapQuest key, generated a while back, wasn't working, so I had to generate a new one.

In looking for answers I also came across this excellent post by ptw‌ with lots of good info about mapping http://qlikshow.com/geocoding-and-maps-visualizations/

Steve

Contributor II
Contributor II

It doesn't seem free any longer or is it me ?

I get this message :

"You have exceeded the number of monthly transactions included with your current plan. If you need additional transactions, please consider upgrading to a plan that offers additional transactions"

I have a database with 2 000 postal codes so if I refresh my qlikview file 10 times, it's 20 000 URLs calculated so I'm over the 15 000 transatcions allowed in the free plan ?

0 Likes
MVP & Luminary
MVP & Luminary

When I was looking there was a limit, I believe.

Can you not work some kind of incremental load where you just do each postcode once and then persist the value?  You could then put an expiry date on each, so that you refresh each post code if it hasn't been checked for a certain amount of time.  You would just need a way of staggering the initial batch.  Perhaps if you checked every thirty days you could set postcodes beginning with A on the 1st, B on the 2nd etc.

Cheers,

Steve

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-04-04 03:40 PM
Updated by: