topic Re: Select in field trigger not working in QlikView

Select in field trigger not working

kris_vliegen — Fri, 03 Jul 2015 14:16:19 GMT

Hi All,

I have a map with fuel-stations.

And in that map I see the fuelstations who has changed today the fuelprice.

If I select a station I select a Latitude(LatitudeChange).

And I would like to see the stations in the neighbourhood.

In my model I have created a table with only the changes of today in and a map with all the prices of all the stations by hour.

So if I select 1 station I (LatitudeChange) I would sub and count 0.05 of the field latitude.

I have created 2 variables

vStartLatChange=MinTijd.(LatitudeChange)- 0.05

vEndLatChange=MinTijd.Latitude + 0.05

I also created 2 "on select" trigger

Clear field Latitude and

Select in field Latitude ='>='&vStartLatChange& '<=' & vEndLatChange

He only select the value of the LatitudeChange.

What Am I doing wrong?

Re: Select in field trigger not working

hic — Fri, 03 Jul 2015 14:37:38 GMT

You could possibly have a problem in the search string. It uses decimal comma, but the field has decimal points. You should use the same decimal separator in both places.

HIC

Re: Select in field trigger not working

kris_vliegen — Fri, 03 Jul 2015 14:40:15 GMT

I can try, but I've also created a text-field with the same trigger on And than it is working fine...

Re: Select in field trigger not working

kris_vliegen — Tue, 07 Jul 2015 13:18:41 GMT

Hi Henric,

I found the solution. There was a link between both tables. I cut-off the link and now everything is working fine.

Thanks for the help