Currency

[#1]

Hi guys.

I got a document that looks like such:

Now what want to do is whenever someone selects USD in the currency box, That the amount shows in USD only. When some clicks on AUD then it displays the sales in AUD amounts.

All the currencies need to be multiplied by certain values in order to get the right amount. I have those values but i can't seem to work it out in the script. I have managed to do it seperatly in the table but in needs to be done in the script so that when the selected currency is made then the whole document changes according to that.

Can anyone help me please?

Thanks in advanced

[#2]

I managed to do an inline statement and mapping it like this:

//Mapping Currency

CurrencyMappingTable:

Mapping

LOAD * INLINE [

F1, F2

USD, *1.0000

CAD, *1.0187

FRF, *1.0000

AUD, *1.0908

GBP, *0.6650

DEM, *1.0000

EUR, *0.7399

];

applymap('CurrencyMappingTable',LocalCurrency) as Currency,

blah blah blah

but the problem is it loads like this:

now my question is, how do load it so it displays USD,AUD,GBP, etc.?

[johnw · Accepted solution]

This may be a little more than what you're looking for, but here's an example based on the assumption that you'll have a different exchange rate for each date. It takes the table of sales, and creates a new table with rows for every sale in every currency. Make a list box that forces you to select one and only one currency, and sales, at the data level, will be in that currency. No multiplication or any other chart tricks. The entire document is affected. If you want to see a particular currency other than the one selected, you can override it with set analysis on a chart-by-chart basis.

[#4]

Is there a way to make it so that if dollars are select than $ is shown, and when Pounds are selected £ is shown, etc?

Thanks for the help

[#5]

no update?

[#6]

anyone?

[#7]

please.....?

[nathanfurby]

You're probably talking Macro territory here. Take a look at this post for some pointers:

http://community.qlik.com/forums/t/30034.aspx

Afraid I can't fill in the blanks

[#9]

Hi Nathan.

Thanks for the reply. The link was a little helpful but not really. could you maybe explain how i can achieve wat i want?

thanks

[nathanfurby]

Like I said, I don't have the answers as I have never done this before. But I imagine how it would work is to create a macro that modifies the number format properties (as in the example) and call it on the currency field event trigger.

Because the documentation is completely useless I wouldn't know which properties to set etc.