Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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...
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
Hi Amars,
Mabybe my explanation wasn't clear. I have added an example to the above qlikview file, Hope that helps ?
Thank you!
Hi Nileshrocks,
maybe this expression will help you, I entered in the variable EURO1 the value 1.95:
If(Seg='EURO1',EURO1,EURO)
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.
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!
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...
Thank you! It worked!!