Hello All,
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.
The script needs to read from the file attached to select the rate for the variables.
looking for the script to set values for vMxRate and vCdRate
if([Paid Currency]='Peso' and [Spend Currency]='Peso' ,[Paid Amount]/$(vMxRate) ,
if(Paid Currency]='CAD' and [Spend Currency]='CAD' ,[Paid Amount]/$(vCdRate),
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.
