topic Re: Exchange rate conversion in QlikView

Exchange rate conversion

settu_periasamy — Mon, 09 Feb 2015 10:24:59 GMT

I have the 3 tables

1st table contains : Customer, Product, Loaded_Currency and List Price.

2nd table contains : EFF_Currency, EFF_CUR_TO, Exchange Rate

3rd table contains : EFF_Currency, Product, Effective Price.

1st table sample data:

2nd table data:

3rd Table:

Now, I need the chart like the Below (Need to shows the two Products and effective price also based on Exchange rate)

i used the expression like the below

=Only([Effective Price])*Only({<EFF_CUR_TO={'$(=Loaded_Currency)'}>}[Exchange Rate]).

But, the result, shows as null... I attached the sample app..

Can you help on this?

Regards,

Settu P

Re: Exchange rate conversion

Gysbert_Wassenaar — Mon, 09 Feb 2015 11:00:20 GMT

A set analysis expression calculates a set at the chart level, not at the row level. That's why your expression does not work if you don't make a selection first. You can use an if-statement instead: =only(if(EFF_CUR_TO=Loaded_Currency,[Exchange Rate]))*[Effective Price]

Re: Exchange rate conversion

settu_periasamy — Wed, 11 Feb 2015 08:15:35 GMT

Thank you Gysbert. I will use if statement.