Creating a filter based on radius

[ammarahw]

I have a field for postal code, latitude, longitude, state and city. The latitude and longitude is based on the center of the postal codes. I want to be able to create a filter that pushes the data out to include other zip codes by their lat/lon coordinates based on whether the user selects 5, 10, 20, 25 or 50 mile radius. Is this possible in Qlik with the data I have available to me?

[Rohan]

Hi @ammarahw ,

You can plot the distance between all the data points that you have. & then you can use that distance field for your slider option. As for how to calculate the distance between the 2 points, check the following article : 

https://community.qlik.com/t5/QlikView-App-Dev/Show-distance-between-two-points/td-p/561286

Hope this helps you to get started.

Regards,

Rohan.

[joshsiddle8]

Plot the distance between your data points and utilize that field for your slider option. This allows for efficient analysis and manipulation of your dataset.

[ammarahw]

I am not sure if this will work since users will be filtering on different zip codes. Or could I create a field that responds to the postal code filter and then make the difference field use that field to calculate the distance to the other zip codes. Is that possible?