topic Conversion Rate Calculation in QlikView https://community.qlik.com/t5/QlikView/Conversion-Rate-Calculation/m-p/1314384#M408223 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I need to use currency conversion rate to calculate expenses for a given month. I need qlik script which i will use as include script to derive the conversion rate for two countries.</P><P></P><P>The script needs to read from the file attached to select the rate for the variables.</P><P>looking for the script to set values for <SPAN style="font-size: 13.3333px;">vMxRate and <SPAN style="font-size: 13.3333px;">vCdRate</SPAN></SPAN></P><P></P><P>if([Paid Currency]='Peso' and [Spend Currency]='Peso' ,[Paid Amount]/$(vMxRate) ,</P><P>if(<SPAN style="font-size: 13.3333px;">Paid Currency]</SPAN>='CAD' and [Spend Currency]='CAD' ,[Paid Amount]/$(vCdRate),</P><P></P><P>The current month rate will be available at the end of the month, so the last month rate will be used for the current till the rate is available.</P></BODY></HTML> Fri, 28 Jul 2017 23:41:24 GMT 2017-07-28T23:41:24Z Conversion Rate Calculation https://community.qlik.com/t5/QlikView/Conversion-Rate-Calculation/m-p/1314384#M408223 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I need to use currency conversion rate to calculate expenses for a given month. I need qlik script which i will use as include script to derive the conversion rate for two countries.</P><P></P><P>The script needs to read from the file attached to select the rate for the variables.</P><P>looking for the script to set values for <SPAN style="font-size: 13.3333px;">vMxRate and <SPAN style="font-size: 13.3333px;">vCdRate</SPAN></SPAN></P><P></P><P>if([Paid Currency]='Peso' and [Spend Currency]='Peso' ,[Paid Amount]/$(vMxRate) ,</P><P>if(<SPAN style="font-size: 13.3333px;">Paid Currency]</SPAN>='CAD' and [Spend Currency]='CAD' ,[Paid Amount]/$(vCdRate),</P><P></P><P>The current month rate will be available at the end of the month, so the last month rate will be used for the current till the rate is available.</P></BODY></HTML> Fri, 28 Jul 2017 23:41:24 GMT https://community.qlik.com/t5/QlikView/Conversion-Rate-Calculation/m-p/1314384#M408223 2017-07-28T23:41:24Z