topic exchange rate matching and calculating in QlikView https://community.qlik.com/t5/QlikView/exchange-rate-matching-and-calculating/m-p/76330#M458311 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an issue, where I tried to combine for quite a while but I dont get it work.</P><P>We have an overall currency table (with a curdoc rate). Additionally I have several data tables (i.e. WriteOff_Details, Invoice_Details) where I need to calculate the EUR-Value. We want this as additional field (or predefined formula in script, which calculated when the field is used in a table) but the main Currency Table must remain.</P><P></P><P>There are two important issues:</P><P>All tables have one date but the currency table has a valid_from and a valid_to field.</P><P>All tables have Landcode (UK, US,...) which is the second parameter to get the correct currency.</P><P><STRONG>How can I reach, that Write-off from 15.02. in UK is taking the rate in GBP from 01.02. until 28.02.?</STRONG></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198911_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 09 Apr 2018 09:36:20 GMT Anonymous 2018-04-09T09:36:20Z exchange rate matching and calculating https://community.qlik.com/t5/QlikView/exchange-rate-matching-and-calculating/m-p/76330#M458311 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an issue, where I tried to combine for quite a while but I dont get it work.</P><P>We have an overall currency table (with a curdoc rate). Additionally I have several data tables (i.e. WriteOff_Details, Invoice_Details) where I need to calculate the EUR-Value. We want this as additional field (or predefined formula in script, which calculated when the field is used in a table) but the main Currency Table must remain.</P><P></P><P>There are two important issues:</P><P>All tables have one date but the currency table has a valid_from and a valid_to field.</P><P>All tables have Landcode (UK, US,...) which is the second parameter to get the correct currency.</P><P><STRONG>How can I reach, that Write-off from 15.02. in UK is taking the rate in GBP from 01.02. until 28.02.?</STRONG></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/198911_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 09 Apr 2018 09:36:20 GMT https://community.qlik.com/t5/QlikView/exchange-rate-matching-and-calculating/m-p/76330#M458311 Anonymous 2018-04-09T09:36:20Z