Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Currency Conversion in QlikView

Hi All,

I am fairly new to QlikView and hence my asking the community. I am building a sales app for a client.

I have a question regarding currency conversion. The client (holding company) requested one of two scenarios for currency conversion.

There are a load of different currencies and all need to be converted to USD. They also want the app to reload daily.

They will be happy with either of these scenarios:

1. A single currency conversion per company per month for historic conversions (excel file). On a daily basis one should then do the conversion from a database table that updates late afternoon(this will only be relevant if one looks at the very latest data (i.e data for the day following the previous nights' reload).  However, this tables' data changes daily and no history is held. They are happy if we take the previous months' average.

Additionally, as a use case one might want to have a look at the sales data ONLY for the current month. The historical averaged monthly data will only be updated on the last day of the month and as I already mentioned, the daily data will not be stored so tere will be a gap!

2. Alternatively they will also be happy with a conversion only on a monthly basis. The gap I just mentioned will therefore still be relevant.

Can anyone give me some advice on how to tackle this problem, possibly with an example?

Thanks in advance!

1 Reply

Re: Currency Conversion in QlikView

Perhaps this blog post will give you ideas: Creating a Date Interval from a Single Date

talk is cheap, supply exceeds demand
Community Browser