Creating map based on addresses in sql DB

[johanru1]

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?

[johanru1]

Ok, I managed to cheat out a result, but I know there must be a better way of doing this.

I set the Expression in the measure to Count(Status) and not show Zero values.

[rubenmarin1 · Accepted solution]

R9 is filtered but Exceptions and R3 doesn't have any 'where' clause to filter data.

You can use keep... (https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPre...)
...or exists... (https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/InterReco...)
... To filter data based in other tables loaded data.

[johanru1]

Thank you so much!

This saved me even more hours of work 🙂