Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Question about variables

Hi,

I have created several variables for different exchange rates, for example $(vCurrencyEUR), $(vCurrencyUSD).

In my expression I would like to choose which variable it should divide with depending on which Currency it has on the transaction row

CompanyCurrencyValue
AEUR50
BUSD60
CGBP40

So if I look at Company A and have an expression like SUM(Amount) I want to divide this with $(vCurrencyEUR) to get the amount in GBP. It it possible to change the variable name in the expression? Something equal to: SUM(Amount) / '$(vCurrency' & [Currency Code] & ')'

Just FYI: I cannot do this in the script since the user want to be able to see all the values to the latest rate, the budget rate or the different periods rates. I.E. I have to divide the value with different rates depending on which choices the user makes in the application.

1 Reply
Not applicable

Re: Question about variables

I know You said You can't do it in script, but could You do something else with script?

for example load extra table (small one, with two fields)?  or it has to be done on presentation layer?