topic Re: Re: Another Longitude and Latitude Question in QlikView

Another Longitude and Latitude Question

Thu, 15 May 2014 20:57:47 GMT

Hi all,

I have a table that holds store address, postal code and the associated Longitude and Latitude for that postal code.

I have a radius selector such as the one the below:

I have a postal code selection box such as the one the below:

What I want to be able to do is once a user chooses a postal code from the above box and the choose a radius, that a chart would display all the stores that are outside the postal code, but with in the selected radius of the postal code.

Any hints or helpers?

Re: Another Longitude and Latitude Question

swuehl — Thu, 15 May 2014 21:32:33 GMT

Maybe like shown here:

How do I use latitude and longitude values to find near by records

Re: Another Longitude and Latitude Question

Thu, 15 May 2014 22:26:10 GMT

Sorry swuehl but its different.

Re: Another Longitude and Latitude Question

swuehl — Thu, 15 May 2014 22:32:52 GMT

Yes, it's not 100% what you requested, but it's showing how to calculate distances between stores given their lat/long coords. Then, after selecting a store, show all near by stores within 1 given distance (1 mile in my example).

So, if I've understood your very short request with no input / output data given correctly, it seems like it's 99% of what you need.

Maybe I am wrong, but 'it's different' is not helping me to help you.

Re: Another Longitude and Latitude Question

Wed, 21 May 2014 18:13:38 GMT

I just added a qvw that might help out.

In this example, when a user chooses the postal code of 49048 and he has any thing selected for the radius, only store 6 should show.

When choosing any other postal code, no store should show because they are not within the radius.

Re: Re: Another Longitude and Latitude Question

arthur_dom — Wed, 21 May 2014 18:54:29 GMT

Se attached QVW. I Used a linear response setting the Dimension between a range of Degrees, 69 Miles is 1 Degree so that was my scale of transformation.

Re: Another Longitude and Latitude Question

Anonymous — Wed, 21 May 2014 19:02:14 GMT

Try the attached, I uploaded it in March to the community, similar question.

Re: Another Longitude and Latitude Question

Wed, 21 May 2014 21:17:26 GMT

Michael,

Could you explain variables "milefactor" and "rc"?

Thank you

Re: Another Longitude and Latitude Question

Anonymous — Wed, 21 May 2014 23:22:08 GMT

Sure.

The milefactor is the radius of our planet in miles. If you use distance in kilometers, the variable must be in kilometers as well.

The rc is to convert degrees in radians. If you divide 360 by 2*pi(), you'll get this rc number (more or less close).

Regards,

Michael