Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Store's assignation

Hi,

I wonder if with QV i could solve this problem, very frequent in geotargetting, as i know how to do in SAS.

Suppose, we have 2 tables.The first one is a prospect file with several fields and XpYp geo-coordinate.

The second one is a file containing some stores (with also XsYs geo-coordinate).

I would like to find for each of my prospect which is the closest store,

for each couple (prospect, store), i need to calculate the distance as sqrt( (Xp-Xs)*(Xp-Xs) + (Yp-Ys)*(Yp-Ys) ) and then find the minimal to get the good store.

Can I do this in the script with some SQL skills or maybe directly in a chart ?

Maybe someone have already exprimented this topic.

Thanks for your help.

jj

Community Browser