topic Re: Handling Currency Table in QlikView

Handling Currency Table

Fri, 11 Apr 2014 05:00:29 GMT

Hi All,

I have a currency table with 2 currency columns, 1 with AUD and other with NZD conversion rates.

I would like to create a list box with values AUD and NZD and when user selects AUD I want to calculate sales * AUD column and when user selects NZD I want to change the calculation to Sales * NZD in the chart list.

Could you please advice best approach to achieve this.

Thanks,

Re: Handling Currency Table

tresB — Fri, 11 Apr 2014 05:45:53 GMT

Try to use system field $Field. To evaluate the values you might try writing expression something like:

=Sum(Sales * $(=$Field) )

$(=$Field) -> will get the NZD/AUD values as per selection.

Re: Handling Currency Table

jagan — Fri, 11 Apr 2014 05:52:15 GMT

Hi,

Try this expression

=Sum(Sales * If(Only(Currency) = 'NZD', NZD, AUD))

** Where Currency is the dimension which is having NZD and AUD to select the currency

Regards,

Jagan.

Re: Handling Currency Table

Sun, 13 Apr 2014 23:41:22 GMT

Thank you tresesco ..If possible can you please send me an example for the same? How to assign $Field to listbox?

Re: Handling Currency Table

Karthik3 — Mon, 14 Apr 2014 00:53:10 GMT

The best way is to do this calculation in the script itself. You will be having two fields in the script one for AUD and one for NZD.

[Sales Value AUD] = Sales*AUD

[Sales Value NZD] = Sales*NZD

Create an Inline table in script with field currency and values AUD and NZD.

In a list box display this currency field and check 'always one selected value'

In chart then use the following expression:-

PICK(MATCH(Currency, 'AUD', 'NZD'), [Sales Value AUD], [Sales Value NZD])