topic Re: How to view data in multiple Currency options in QlikView

How to view data in multiple Currency options

Mon, 24 Sep 2012 14:35:58 GMT

Can anyone help???

I am building an app and one of the requirements is to allow the user to be able to select different currencies. I know that a variable needs to be created but not sure how to go about it.

I have created the inline load below which is a Data Island in my data model:

Currency:

LOAD * INLINE

[

CURRENCY, ExchangeRate

AUD, 1.0908

CAD, 1.0187

EUR, 0.7399

GBP, 0.6650

USD, 1.000

]

I want the user to be able to select one of the five currency's from a list box and all related numbers should change to the selected currency.

Sample app attached.

Thanks!

Re: How to view data in multiple Currency options

christophebrault — Mon, 24 Sep 2012 14:44:32 GMT

Hi,

In you listbox, force to one selected value.

Then add *ExchangeRate to all you expressions, and it's done !

Re: How to view data in multiple Currency options

daveamz — Mon, 24 Sep 2012 14:58:18 GMT

Hi,

Like Chris said, you'll have to use * ExchangeRate in your expressions sum(Sales*ExchangeRate)

BR,

David

Re: How to view data in multiple Currency options

Mon, 24 Sep 2012 15:02:15 GMT

Alot simpler than I thought!

Thanks for your help guys!

Re: How to view data in multiple Currency options

Wed, 22 May 2013 01:15:40 GMT

So, how did your Dev Cert App turn out?

Re: How to view data in multiple Currency options

a272070 — Fri, 13 Sep 2019 14:56:37 GMT

Hi,

In your sample application, what is the original currency? Would you just not include whatever it is in the list box "currency"? Is there a way to label it originally what it is or not?

Thanks!