Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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¢er='
&
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
Please give suggestions
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.
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?
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¢er='
&
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.