Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Exchange rate conversion

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

1 Solution

Accepted Solutions

Re: Exchange rate conversion

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]


talk is cheap, supply exceeds demand
2 Replies

Re: Exchange rate conversion

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]


talk is cheap, supply exceeds demand

Re: Exchange rate conversion

Thank you Gysbert. I will use if statement.

Community Browser