HOW TO CHANGE EURO VALUE ??

[#1]

I have a table called COUNTRY with the following, SINGAPORE, INDONESIA, MALAYSIA and THAILAND. this is the problem i'm facing :

When i click the SINGAPORE tab under COUNTRY, my exchange rate for EURO is 2.2.

But when i click the INDONESIA, INDONESIA and MALAYSIA tabs, they must change from EURO = 2.2 to EURO=1.95.

Since the formula i have is using 1 EURO variable, he equation alongside with the 4 COUNTRIES would be the same,

How do i change it such that, when i click SINGAPORE, the EURO value is 2.2, and when i click the other 3 countries, the EURO value is 1.95.

Since i have added the expression for (example) PANEL to be :

money(sum(ceil((PRICE*EURO*FREIGHTCHARGE*DISCOUNT*Rate/PANEL),0.5)),CurrencyFormat) ,

THANKS!

[amars]

Hi Nilesh,

you will get many post related to Currency Conversion like http://community.qlik.com/forums/t/38309.aspx. The basic idea over here is like you have a conversion table containing fields like ( FromCurrency, ToCurrency & ConversionRate ). Now here ToCurrency is the currency in which u wish to see the transaction amount. We can restrict the the ToCurrency to a single value using Always one selected value tag in the General properties of the list containing ToCurrency.(Given u select a value the checkbox gets enabled).

See if this helps.

Thanks

[#3]

Hi Amars,

Mabybe my explanation wasn't clear. I have added an example to the above qlikview file, Hope that helps ?

Thank you!

[brenner_martina]

Hi Nileshrocks,

maybe this expression will help you, I entered in the variable EURO1 the value 1.95:

If(Seg='EURO1',EURO1,EURO)

[amars]

Sorry Nilesh, my bad.....

See if the attached example helps.

Frankly I don't feel the way I have solved this with macro can be done using actions in Qlikview 9 or 10 but as I have done it in 8.5 it is using macros.

[#6]

I tried everything you showed me. It could work, but when i copied it over, i could not use it. Here is the sample of it, please look through it.

Thanks!

[amars · Accepted solution]

Hi Nilesh,

For the macro to work Go in Document Properties -> macros -> Field Event Triggers-> Select Currency & in OnSelect drop down select the macro by clicking on the dropdown. And it will start working...

Thanks..

If this answered you question Please select Mark as an answer...

[#8]

Thank you! It worked!!