topic Using Google maps at county level in Qlikview in QlikView

Using Google maps at county level in Qlikview

Tue, 09 Jul 2013 07:34:44 GMT

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

Re: Using Google maps at county level in Qlikview

Tue, 09 Jul 2013 11:35:44 GMT

here is an example.

Check following tab :

- Dimension

- Expression

- Axis

- Colours

and just plug your data in place of mine

best regards

Chris

Re: Using Google maps at county level in Qlikview

Tue, 09 Jul 2013 14:49:54 GMT

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