Switch currency to view data

[#1]

Hello there,

I created two tables in Access, one is Fdetail, another is Exchange, then I created one chart in QlikView to calculate Cost, Profit, Sale total sum result. I hope to switch currency to show sum data, but don't know how to make it work. Does anyone can give me a hand? Thanks a lot.

[vishsaggi]

What is the expected output you are looking for? Can you share a sample here?

[Kushal_Chawda]

ink Your Exchange tabe to detail table

Your Expression should be

Sum(Profit) * only(Rate)

[#4]

Hi, my expected output is like this:

As the screenshot, marked in red, when I switch to different currency, the data in chart could change automatically.

[#5]

Hi, you mean input the expression in tlsh this chart, right?

[#6]

Guys, I input

if(Currency='JPY',sum(Cost),sum(Cost/Rate))

in expression, however, when I switch to USD currency, the chart display nothing, does anybody know the reason?