Currency conversion for MTD,YTD

[gauthamchilled]

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.

[PrashantSangle]

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

[gauthamchilled]

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?

[PrashantSangle]

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