Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am new to Qlikview and trying to use googlemaps for Patients mapping
my data looks like this
Service | Patient Name | Postcode |
Mental Health | a1 | nn1 3nl |
Mental Health | a2 | nn1 3pz |
Mental Health | a3 | nn1 2pq |
Mental Health | a4 | nn10 5pd |
Mental Health | a5 | nn11 3ec |
Mental Health | a6 | nn2 3ny |
Mental Health | a7 | nn4 5pf |
Sexual Health | a8 | nn6 5fr |
Sexual Health | a9 | nn1 3mg |
Sexual Health | a10 | nn8 7nf |
Sexual Health | a11 | nn8 7nf |
Sexual Health | a12 | nn8 7nf |
Sexual Health | a13 | nn8 7nf |
Sexual Health | a14 | nn4 4er |
Community Services | a15 | nn8 7nf |
Community Services | a16 | nn14 5he |
Community Services | a17 | nn8 7nf |
Community Services | a18 | nn8 7nf |
Community Services | a19 | nn3 8gr |
Community Services | a20 | nn8 7nf |
Community Services | a21 | nn8 7nf |
Health Visit | a22 | nh17 8gf |
Health Visit | a23 | nn8 7nf |
Health Visit | a24 | nn6 7fr |
Health Visit | a25 | nn8 7nf |
Health Visit | a26 | nj3 7tr |
Health Visit | a27 | nn8 7nf |
Health Visit | a28 | nn8 7nf |
Could anyone suggest how I can plot on Google map
Thanks inadvance
SP
Hi
here is an example.
Check following tab :
- Dimension
- Expression
- Axis
- Colours
and just plug your data in place of mine
best regards
Chris
Hi Christianj,
Many thanks for your help. Its very good start. I managed to plot on the map but I can't zoom at higher Level. The maximum I am able to zoom as follows
Is there any source that I can download all the Postcodes Longitude and Lattitudes for UK at county Level (Cambridgeshire, Leicestershire,Northamptonshire etc..). As I can find only Prefix level Longitudes and lattitudes (ex: for Cambridgeshire CB1, CB2,CB3 etc..)
Many many thanks for your help. Much appreciate
Thanks SP