Discussion Board for collaboration related to Creating Analytics for QlikView.
I have the table with budget amount in companywise and monthwise.
but the amount is in different currency in different month for same company.
that is for jan month they gave in USD, in Feb they give in EUR, Mar they give in EUR.
but i need to show the output in SGD.
if user selects jan, then i need to show the value as sum of USD amt multiplied by currency rate of Jan.
the tricky part is,
suppose user select Q1,i.e,Jan,Feb,Mar then i need to sum(USD Amt) and Sum(EUR Amt) multiplied by threir respective currency rate for the month Mar rate.
so the output is like USD amt multiplied by the mar month rate and EUR amt multiplied by the Mar month rate.
If it is same currency i can multiply based on their currency.
but i dont know how to do for this type of different currency.
Here with I have attached a soln.I hope it will help ful.
thanks for your reply.
I have the month wise exchange rate.
based on the month the value will get change.
please find an easy solution attached. The script shows some comments, so that you can adopt the method and adjust it according to your needs. Make sure you load all conversion rates and link them correctly to your data.
Hope this helps you further.
thanks for all your reply.
Already i solved this problem using some other method.
I am Nitin.
Even I am facing problem in currency conversion.
I my case currency rates are maintained on day basis.
Suppose rate of euro to INR on 1 Jan is 68 and on 8 jan it changes to 71.
I am creating a chart having current year vs last year sales comparison. Here I have to check what is the exchange rate previous year on date basis and in current year. Hope you understand my query.
If you have some example , it would be a greeat help.
can you provide sample file and mention what do you want ...
Thanks for showing interest in helping me out.
Please follow the below link, as I had registered in discussions in community forums.
The data and my need is present there. But I have not received the desired solution.
Please look into the matter.