topic Re: Problem using SelectTextsInColumn in QlikView https://community.qlik.com/t5/QlikView/Problem-using-SelectTextsInColumn/m-p/1047876#M1232935 <HTML><HEAD></HEAD><BODY><P>I found the solution.</P><P>The code (only the marker event) must be changed as below:</P><P></P><P>marker.on('dblclick', function(<SPAN style="text-decoration: line-through;">e</SPAN>) {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: line-through;">_this.Data.SelectTextsInColumn(2, true, row[2].text);</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var latSel = <STRONG>this.</STRONG>getLatLng().lat.toString().replace(".",",");</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var lonSel =<STRONG> this.</STRONG>getLatLng().lng.toString().replace(".",",");</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _this.Data.SelectTextsInColumn(0, true, latSel);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _this.Data.SelectTextsInColumn(1, true, lonSel);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; });</P><P></P><P>Now it works correctly.</P></BODY></HTML> Wed, 10 Feb 2016 07:21:44 GMT 2016-02-10T07:21:44Z Problem using SelectTextsInColumn https://community.qlik.com/t5/QlikView/Problem-using-SelectTextsInColumn/m-p/1047875#M1232933 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I'm new in QlikView.<BR />I built an extension to display my stores on a map (using Leaflet) and I want to send the store name (row[2]) to QlikView when I doubleclick on the icon store.</P><P>I tryed in this way:</P><P></P><P>for (var i=0,k=_this.Data.Rows.length;i&lt;k;i++){<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var row = _this.Data.Rows <I>;</I></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var latitude = parseFloat(row[0].text.replace(",","."));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var longitude = parseFloat(row[1].text.replace(",","."));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Check to see coordinates are valid<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (latitude != NaN &amp;&amp; latitude !='' &amp;&amp; latitude &lt;= 90 &amp;&amp; latitude &gt;= -90 &amp;&amp; longitude != NaN &amp;&amp; longitude !='' &amp;&amp; longitude &lt;= 180 &amp;&amp; latitude &gt;= -180) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var latlng = new L.LatLng(latitude, longitude);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var poptext = 'Lat &amp; Long:'+latlng+'&lt;br/&gt;'+ row[2].text +'&lt;br/&gt;'+ 'Measure: ' + row[4].text;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var marker = L.marker(latlng).addTo(map).bindPopup(poptext);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; marker.on('dblclick', function(e) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _this.Data.SelectTextsInColumn(2, true, row[2].text);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; });<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } else {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Need to figure out a method of notifiying bad lat and longitudegs...<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp; <BR />Stores are corrected displayed in the map, but when I doubleclik, I send to QlikView always the last store fetched by the loop, not the selected one.<BR />What I'm doing wrong?<BR />Thanks in advance.</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/Problem-using-SelectTextsInColumn/m-p/1047875#M1232933 2026-01-26T16:26:21Z Re: Problem using SelectTextsInColumn https://community.qlik.com/t5/QlikView/Problem-using-SelectTextsInColumn/m-p/1047876#M1232935 <HTML><HEAD></HEAD><BODY><P>I found the solution.</P><P>The code (only the marker event) must be changed as below:</P><P></P><P>marker.on('dblclick', function(<SPAN style="text-decoration: line-through;">e</SPAN>) {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: line-through;">_this.Data.SelectTextsInColumn(2, true, row[2].text);</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var latSel = <STRONG>this.</STRONG>getLatLng().lat.toString().replace(".",",");</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var lonSel =<STRONG> this.</STRONG>getLatLng().lng.toString().replace(".",",");</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _this.Data.SelectTextsInColumn(0, true, latSel);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _this.Data.SelectTextsInColumn(1, true, lonSel);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; });</P><P></P><P>Now it works correctly.</P></BODY></HTML> Wed, 10 Feb 2016 07:21:44 GMT https://community.qlik.com/t5/QlikView/Problem-using-SelectTextsInColumn/m-p/1047876#M1232935 2016-02-10T07:21:44Z