Discussion Board for collaboration on QlikView Scripting.
This is my second attempt at asking the same question. In my first attempt (Points In Polygon), I do not think I was able to explain the problem properly. Apologies. So here I go again ...
I am provided with area co-ordinates and using QV I need to show if customers fall inside or outside this area.
Area:load * inline [Area_X,Area_Y0,04,02,24,40,40,0];
Customer:Load * inline [Customer_ID, Cust_X, Cust_Y1000001,1,31000002,3,2];
Desired Result :[Customer_ID, Cust_X, Cust_Y, Inside_Outside_Indicator1000001,1,3, Inside1000002,3,2, Outside];
Please let me know if you need any further information. Any help will be greatly appreciated.
PS: I don't know if I need to use (or how to use) linest_m and linest_b to work out the line equation between points.
Go to Solution.
I think it might be a tad optimistic to try and create a ray-casting algorithm on the fly in QlikView.
If you're OK with doing it script-side, you should be able to adapt the algorithms listed here:
Or better yet, calculate it at the database level, depending on your database:
oracle - Ray Casting With Pl/SQL Function - Stack Overflow
Thanks for the quick response Or Shosham.
I will try doing it at database level and let you know how it goes. I have a SQL Server 2014 database.
Hi Or Shosham,
It's working !!
Thanks a million!
I have the same issue in my project.
Could you give us an example of how you implemented it in your application ?
Thanks in advance.