topic HOW TO CHANGE EURO VALUE ?? in QlikView

HOW TO CHANGE EURO VALUE ??

Fri, 11 Mar 2011 05:42:20 GMT

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!

HOW TO CHANGE EURO VALUE ??

amars — Fri, 11 Mar 2011 06:40:13 GMT

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

HOW TO CHANGE EURO VALUE ??

Fri, 11 Mar 2011 07:20:42 GMT

Hi Amars,

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

Thank you!

AW:Re: HOW TO CHANGE EURO VALUE ??

brenner_martina — Fri, 11 Mar 2011 08:34:46 GMT

Hi Nileshrocks,

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

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

HOW TO CHANGE EURO VALUE ??

amars — Fri, 11 Mar 2011 08:57:43 GMT

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.

HOW TO CHANGE EURO VALUE ??

Fri, 11 Mar 2011 10:02:56 GMT

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!

HOW TO CHANGE EURO VALUE ??

amars — Mon, 14 Mar 2011 08:06:15 GMT

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...

HOW TO CHANGE EURO VALUE ??

Mon, 14 Mar 2011 08:31:53 GMT

Thank you! It worked!!