help scripting - value not appearing

qlikmpate0 — Wed, 21 Mar 2018 10:58:30 GMT

Problem trying to get a conversion rate for each transaction.

Background, Conversion rate are set up on monthly basics, so if a transaction falls within that month I would like to get the conversion rate.

My final output look like this.

The columns highlighted (Curr C/L, O/S Invs, App Ords, Total exposure, avail Credit line), need to be converted to Euros, but the all columns are already in euros except the last customer United Kingdom.

So I had an idea great in theory but not in practice.

I need to get a date of the transaction, find the from budget currency and to budget currency ie GBP to EUR and EUR to EUR then use that conversion rate, but my theory isn’t showing any values for conversion rate.

Thanks in advance.

regards

topic help scripting - value not appearing in QlikView

help scripting - value not appearing