Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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
Highlighted
MVP & Luminary
MVP & Luminary

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

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

View solution in original post

Highlighted

Thank you Gysbert. I will use if statement.