topic Script calculation in QlikView https://community.qlik.com/t5/QlikView/Script-calculation/m-p/546756#M684151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 3 files with data in multiple currencies and 1 file with the Currency Rates.</P><P>I would like to have the script to look at the Currency field in the data table(s), find the corresponding Rate in the Currency Table and calculate the Euro rate, the have the result of that calculation show up as a column.</P><P></P><P>I'm still pretty new at this, so can anyone give me some pointers on how to do this? So far, all my attempts have failed.</P><P>Would be much appreciated.</P></BODY></HTML> Tue, 21 Jan 2014 18:59:00 GMT 2014-01-21T18:59:00Z Script calculation https://community.qlik.com/t5/QlikView/Script-calculation/m-p/546756#M684151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 3 files with data in multiple currencies and 1 file with the Currency Rates.</P><P>I would like to have the script to look at the Currency field in the data table(s), find the corresponding Rate in the Currency Table and calculate the Euro rate, the have the result of that calculation show up as a column.</P><P></P><P>I'm still pretty new at this, so can anyone give me some pointers on how to do this? So far, all my attempts have failed.</P><P>Would be much appreciated.</P></BODY></HTML> Tue, 21 Jan 2014 18:59:00 GMT https://community.qlik.com/t5/QlikView/Script-calculation/m-p/546756#M684151 2014-01-21T18:59:00Z Re: Script calculation https://community.qlik.com/t5/QlikView/Script-calculation/m-p/546757#M684152 <HTML><HEAD></HEAD><BODY><P>Check this: <A href="https://community.qlik.com/thread/14809">Currency Conversion</A></P></BODY></HTML> Tue, 21 Jan 2014 19:01:56 GMT https://community.qlik.com/t5/QlikView/Script-calculation/m-p/546757#M684152 Clever_Anjos 2014-01-21T19:01:56Z Re: Script calculation https://community.qlik.com/t5/QlikView/Script-calculation/m-p/546758#M684153 <HTML><HEAD></HEAD><BODY><P>If you have the Currency rate on each day, just add the currency rate based on your transaction date with ApplyMap.</P><P></P><P>Please post some sample data</P></BODY></HTML> Tue, 21 Jan 2014 19:07:29 GMT https://community.qlik.com/t5/QlikView/Script-calculation/m-p/546758#M684153 2014-01-21T19:07:29Z