Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create a map based on addresses we have in a SQL DB.
Is there any way of doing this?
PS. I do see the massive issue with spelling errors and so on, but hopefully someone has figured out a smart way of getting around that issue as well.
If none of this is possible, I would like to see if I can pull the postcodes directly from our SQL and get the Latitude/Longitude from a separate spread sheet?
Hi Joahn,
Qlik will show the points based on the source database. If you have incorrect speeling or address, you need to fix it previously.
Take a look on this topic in order to understand the Map chart.
Hi @Ricardo_Gerhard,
And thank you for the swift reply.
I seem to have all the parameteres I need, and the postcodes (Which it looks like I will be using are correct).
I'm just having trouble making Qlik understand that these are Geo points.
All the postcodes are located in Norway and would love it if I could limit it to pull from one table, but if needed, I can pull the ISO name or Country name from a few steps into some other tables.
Is there a specific geopoint I need to set for Qlik to interpret the data correctly?
Hi,
So far I know you can only go to ZIP (postal code) or city/place level with default maps. To go to street level you will need the coordinates.
A software like Geocoding (https://bi.idevio.com/products/qlik-geocoding) can help to retrieve the coordinates of the addresses.
Luckily that is all I need 🙂
I just can't seem to get Qlik to interpret the fields correctly.
I'm not sure if I have understand your issue... maybe adding a field to set location type and/or country?:
Hi again,
The problem is that I don't even get an option to add a dimension at the current stage.
I might be lacking some really basic knowledge here to be honest, so feel free to dumb it down for me 🙂
As a side question, would the ZIP (Postal Code) need to look like this: NO-4809 f.ex?
At the moment my codes are following Norwegian standard with the country code in it, but City name is present.
Edit: Tried just pulling data from our country table, and even that did not work:
Thank you so much for your help.
Since my Qlik is not recognizing any of my fields as geopoints, I have ended up back with my spreadsheet that contains the Longitude/Latitude.
The issue I am facing now, is that it pulls all the data, even though I believe I have told it to only pull data if certain critieria is met.
My current code:
[R9]: LOAD [CustNo] AS [CustNo], [St] AS status, [R1] AS avdeling, [R3] AS Anlegg; SQL SELECT "CustNo", "St", "R1", "R3" FROM "F0001"."dbo"."R9" where st = '3'; Exceptions: LOAD [POSTNR] AS [PNo-POSTNR], [Latitude] AS [Latitude], [Longitude] AS [Longitude], GeoMakePoint([Latitude], [Longitude]) AS [Longitude_Latitude]; LOAD [POSTNR], [Latitude], [Longitude] FROM [lib://AttachedFiles/postnummer.xlsx] (ooxml, embedded labels, table is postnummer); [R3]: LOAD [PNo] AS [PNo-POSTNR], [PArea] AS [PArea], [RNo] AS Anlegg; SQL SELECT "PNo", "PArea", "RNo" FROM "F0001"."dbo"."R3";
What I really want, is to only pull data where st = '3'.
I really thought I had some sort of knowledge regarding this, but seems hopeless at the moment.