Hi Qlik Community!
Here's my issue: I want to create a variable (vExchangeRate) that takes the average of the EUR:USD exchange rates of the last 30 days.
I have a Forex Table in my data model like this:
![Captura de pantalla 2015-10-28 a las 1.45.49 PM.png](/legacyfs/online/103339_Captura de pantalla 2015-10-28 a las 1.45.49 PM.png)
Then I want to use this variable in a chart to calculate some fees. How could I do this in the Load Script? Is there a better way? I've though of Set analysis but would like to do it in the Load Script.
Thanks!