Question about variables

Tue, 05 Feb 2013 11:48:58 GMT

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

Company	Currency	Value
A	EUR	50
B	USD	60
C	GBP	40

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.

Re: Question about variables

Fri, 08 Feb 2013 11:21:20 GMT

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?

topic Question about variables in QlikView

Question about variables

Re: Question about variables