topic Re: Switch currency to view data in QlikView

Switch currency to view data

Thu, 22 Jun 2017 09:12:33 GMT

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.

Re: Switch currency to view data

vishsaggi — Thu, 22 Jun 2017 16:44:55 GMT

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

Re: Switch currency to view data

Kushal_Chawda — Thu, 22 Jun 2017 16:53:24 GMT

ink Your Exchange tabe to detail table

Your Expression should be

Sum(Profit) * only(Rate)

Re: Switch currency to view data

Fri, 23 Jun 2017 00:52:20 GMT

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.

Re: Switch currency to view data

Fri, 23 Jun 2017 00:56:47 GMT

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

Re: Switch currency to view data

Wed, 28 Jun 2017 01:45:00 GMT

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?