topic Re: map not working properly in QlikView

map not working properly

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i m doing maps for the first time in qlikview.

in my scatter chart, in the colours tab -> Dynamic Image has the following expression:

='http://geomap.nagvis.org/?module=map&center='

num(var_mid_long, '###.######')

&','

num(var_mid_lat, '###.######')

'&zoom=$(var_zoom)'

'&type=mapnik'

'&width='&map_size_x&'&height='&map_size_y

'&logoPos=leftDownCorner&scaleBarPos=rightDownCorner&points='&CONCAT($(=IF(Show_all_areas='Y','{1}',' ')) left(Long,6)&','&left(Lat,6)&',pointImagePattern:'&Symbol&';')

Long, Lat are my fixed Latitude & Longitude

Symbol is the field having values like A, B, C... corresponding to the fixed Latitude & Longitude

Show_all_areas is the variable with values Y,N

if it is Y, then it should show some areas.

i have a input box on the map to show this variable value. but if i select Y, nothing got changed on the map.

is the above expression wrong. i dont know how to fix this.

can anyone please help

Re: map not working properly

Thu, 15 Sep 2016 08:27:22 GMT

Please give suggestions

Re: map not working properly

adamdavi3s — Thu, 15 Sep 2016 10:55:40 GMT

I recently did a lot of debugging trying to get mapbox maps working.

The way I did it was to put my expression in a textbox, you can then see it change as you change things.

You also then have the right click option of "copy text" which you can then paste into a browser to see the map.

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

Re: map not working properly

Fri, 16 Sep 2016 08:28:41 GMT

No.

in text box also not working.

the error is in here

&CONCAT($(=IF(Show_all_areas='Y','{1}',' ')) left(Long,6)&','&left(Lat,6)&',pointImagePattern:'&Symbol&';')

Can anyone please help me to correct this expression?

Re: map not working properly

adamdavi3s — Fri, 16 Sep 2016 08:35:57 GMT

Ok, so what are you expecting the URL to be if show all areas is Y or not Y?

I am not familiar with the url syntax for this mapping solution

I mean if you're just saying if = Y then input {1} otherwise ' ' then the syntax is

='http://geomap.nagvis.org/?module=map&center='

num(var_mid_long, '###.######')

&','

num(var_mid_lat, '###.######')

'&zoom=$(var_zoom)'

'&type=mapnik'

'&width='&map_size_x&'&height='&map_size_y

'&logoPos=leftDownCorner&scaleBarPos=rightDownCorner&points='&IF(Show_all_areas='Y','{1}',' ')& 'left(Long,6)'&','&left(Lat,6)&',pointImagePattern:'&Symbol&';'

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.