topic Store's assignation in QlikView https://community.qlik.com/t5/QlikView/Store-s-assignation/m-p/224665#M715055 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I wonder if with QV i could solve this problem, very frequent in geotargetting, as i know how to do in SAS.</P><P>Suppose, we have 2 tables.The first one is a prospect file with several fields and XpYp geo-coordinate.</P><P>The second one is a file containing some stores (with also XsYs geo-coordinate).</P><P>I would like to find for each of my prospect which is the closest store,</P><P>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.</P><P>Can I do this in the script with some SQL skills or maybe directly in a chart ?</P><P>Maybe someone have already exprimented this topic.</P><P>Thanks for your help.</P><P>jj</P><P></P></BODY></HTML> Wed, 27 Jan 2010 18:35:23 GMT 2010-01-27T18:35:23Z Store's assignation https://community.qlik.com/t5/QlikView/Store-s-assignation/m-p/224665#M715055 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I wonder if with QV i could solve this problem, very frequent in geotargetting, as i know how to do in SAS.</P><P>Suppose, we have 2 tables.The first one is a prospect file with several fields and XpYp geo-coordinate.</P><P>The second one is a file containing some stores (with also XsYs geo-coordinate).</P><P>I would like to find for each of my prospect which is the closest store,</P><P>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.</P><P>Can I do this in the script with some SQL skills or maybe directly in a chart ?</P><P>Maybe someone have already exprimented this topic.</P><P>Thanks for your help.</P><P>jj</P><P></P></BODY></HTML> Wed, 27 Jan 2010 18:35:23 GMT https://community.qlik.com/t5/QlikView/Store-s-assignation/m-p/224665#M715055 2010-01-27T18:35:23Z