topic Re: Plot longitude and latitude of postal codes in the correct aspect ratio in a QLikView scatter chart in QlikView

Plot longitude and latitude of postal codes in the correct aspect ratio in a QLikView scatter chart

qlikmark1990 — Thu, 26 Apr 2018 08:39:03 GMT

I tried to plot the longitude and latitude of postal code data from the Netherlands in a QLikView scatter chart.So far I have this chart :

The data that I used is NL.zip, downloaded from GeoNames

I want to remove the empty space below and above. How can I short the Y-axis from 50,8 to 53,6?

A second problem is zoom in :

When I perform the selection as above, I'd like to have this selection on the whole graph and keep the same aspect ratio. The result that I get now is shown below :

Things that I already did are :

Axes > tick of 'Forced 0' for both axes

Ticked of 'Show Legend'

Later I want to add a picture of the Netherlands as background and align the data points on the picture. If keeping the same aspect ratio the data points should be still aligned with the image while zooming in.

Re: Plot longitude and latitude of postal codes in the correct aspect ratio in a QLikView scatter chart

stigchel — Thu, 26 Apr 2018 11:38:28 GMT

I once found this solution for creating a static map, but I don't think you will be able to zoom using a static picture. Instructions in the qvw.

Re: Plot longitude and latitude of postal codes in the correct aspect ratio in a QLikView scatter chart

qlikmark1990 — Thu, 26 Apr 2018 11:40:29 GMT

Unfortunately I can't open the file.

Re: Plot longitude and latitude of postal codes in the correct aspect ratio in a QLikView scatter chart

stigchel — Thu, 26 Apr 2018 11:53:20 GMT

Ok, well here are the instructions and a screenshot

// 1. Open url: http://www.openstreetmap.org/

// 2. Click on "Export".

// 3. Adjust the map if you know the geo coordinates

// or adjust a map extract with your mouse.

// 4. Enter the minimum and maximum long- and latitude, shown to the left of the map:

SET vCoordinateMinX=3.24;

SET vCoordinateMaxX=7.35;

SET vCoordinateMinY=50.75;

SET vCoordinateMaxY=53.51;

// 5. Enter the width and height of the export-image, shown above the export-button:

// Tip: You can adjust the scale to modify the size of the map

SET vImageMaxX=933;

SET vImageMaxY=1073;

// 6. Export the map as image and save it on your computer.

// 7. Load your data. It has to contain the postcode

GeoInfo:

LOAD * Inline [Naam,4PP, Score

'A',7206,100

'B',1336,100

'C',8232,75

];

// Load geodata.

LEFT JOIN

LOAD * FROM ..\4pp.xls (biff, embedded labels, table is [4pp$]);

As X expression

=(Longitude-vCoordinateMinX) * (vImageMaxX / (vCoordinateMaxX-vCoordinateMinX))

As Y expression

=(Latitude-vCoordinateMinY) * (vImageMaxY / (vCoordinateMaxY-vCoordinateMinY))

Set the Axis settings Static Min to 0 for both axes

And the Static max to =vImageMaxX and =vImageMaxY

Re: Plot longitude and latitude of postal codes in the correct aspect ratio in a QLikView scatter chart

qlikmark1990 — Mon, 30 Apr 2018 08:08:15 GMT

Thanks you for this very clear answer, unfortunately I always get a Gateway Timeout while trying to export the map. I tried several times in the afternoon and morning.

Re: Plot longitude and latitude of postal codes in the correct aspect ratio in a QLikView scatter chart

stigchel — Mon, 30 Apr 2018 10:13:44 GMT

Yes, unfortunately. Maybe there are some other sites or you could just make a screenshot. You'd have to guesstimate the coordinates....

I have attached the map for NL that I exported from openstreetmap once, it is the one used in the qvw, so all details are as described above.