Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mapquest Map, Points not autosizing

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,

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

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

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

to

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

to

    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

View solution in original post

3 Replies
jochem_zw
Employee
Employee

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.##','.',','))

JonnyPoole
Former Employee
Former Employee

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

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

to

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

to

    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

Not applicable
Author

Thanks Jonathan & Jochem,

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

Now onto the next head wrecker! thanks again