topic Re: Currency conversion for MTD,YTD in QlikView

Currency conversion for MTD,YTD

gauthamchilled — Fri, 20 Nov 2015 03:56:49 GMT

If I have exchange rates on monthly basis, and if I want to display YTD calculation in a chart, how can I apply the conversion since I have rates for each month. Do you have any idea? Please help.

Thanks.

Re: Currency conversion for MTD,YTD

PrashantSangle — Fri, 20 Nov 2015 04:15:09 GMT

Hi,

Do you Currency Conversion in script not in front end.

Also if you have proper association between your Exchange rate table and Currency table then you no need to worry about Conversion just try with normal YTD,MTD experession.

Regards

Re: Currency conversion for MTD,YTD

gauthamchilled — Fri, 20 Nov 2015 05:00:11 GMT

I mapped exchange rate date with master calendar date, both are just month start dates.

Ex: incase below is my expression

=SUM({$<YourDateField = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}Sales/Exrate)

which rates, it will take?

Re: Currency conversion for MTD,YTD

PrashantSangle — Fri, 20 Nov 2015 05:06:32 GMT

Hi,

If YourDateField is from Master Calender Table and Your master Calender Table is mapped with Date of Sales Table then Exrate indirectly mapped with date of sales table so in this case Exrate will take on the basis of Sales Date

Hope you understand the power of association in QlikView.

Still confusion????

Regards