topic Re: Mapquest Map, Points not autosizing in QlikView

Mapquest Map, Points not autosizing

Tue, 19 Aug 2014 14:06:47 GMT

Hi Folks,

I have created the attached map of Ireland plotting some counties (all containing random data) then using the MapQuest connection plotting it against a map to show in the correct location.

I am looking to have each county point increase or decrease depending on the quantity of sales, I have tried various methods for this however the points stay resolutely uniform in size.

Is there a way to have them dynamically resize? Its probably something simple that I'm missing...

thanks in advance,

Re: Mapquest Map, Points not autosizing

jochem_zw — Tue, 19 Aug 2014 14:23:02 GMT

Your number format for the CustomerQuantity is not correct.

If you do a sum on this field it returns 0.

maybe this can help you:

sum(num#(CustomerQuantity,'#,##0.##','.',','))

Re: Mapquest Map, Points not autosizing

JonnyPoole — Tue, 19 Aug 2014 14:31:12 GMT

Played around with your number formatting in the script i changed 2 areas:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

and

		Replace([results/result/locations/location/latLng/lat], '.', ',')		as latitude,
		Replace([results/result/locations/location/latLng/lng], '.', ',')		as longitude

		Replace([results/result/locations/location/latLng/lat], ',', '.')		as latitude,
		Replace([results/result/locations/location/latLng/lng], ',', '.')		as longitude

...then hit reload and it should work

Re: Mapquest Map, Points not autosizing

Tue, 19 Aug 2014 14:46:40 GMT

Thanks Jonathan & Jochem,

Had to implement both your suggestions however my points are now dynamically resizing.

Now onto the next head wrecker! thanks again