topic Re: currency conversion on section access in QlikView

currency conversion on section access

gauthamchilled — Thu, 29 Oct 2015 02:45:26 GMT

Hi,

How to change the currency automatically for the entire dashboard if the region of the dashboard is different.

Or how can I change the currency for different user based on section access

Re: currency conversion on section access

tresB — Thu, 29 Oct 2015 05:06:38 GMT

Try like this:

Re: currency conversion on section access

Anonymous — Thu, 29 Oct 2015 05:30:00 GMT

Hi,

As Tresesco explained, confirm the currency types and use row level security of section access. Use the reduced currency field in the format of num fucntion.

HTH

Re: currency conversion on section access

gauthamchilled — Thu, 29 Oct 2015 05:31:38 GMT

hi tresesco,

thanks for the reply. I want to convert the whole data into other countries currency. Exchange rates are on daily basis. so if user 1 is US and user 2 is UK. user 2 should see all the region data in pounds. how can I achieve this? currently the data is US$.

Gautham.

Re: currency conversion on section access

Anonymous — Thu, 29 Oct 2015 05:37:24 GMT

load this Currency Exchange Table (US Dollar) - X-Rates into web file loader in QV and reload.. you will have a table

Re: currency conversion on section access

tresB — Thu, 29 Oct 2015 05:51:42 GMT

Add one more column to hold the conversion rate like:

And change the expression to like:

Num(Sum(Sales)*ConvRate,Currency &'#,##0.00;'&'Currency'&' -#,##0.00')

Re: currency conversion on section access

gauthamchilled — Thu, 29 Oct 2015 06:03:50 GMT

as conversion rate is not fixed and it changes everyday...still it work?

Re: currency conversion on section access

tresB — Thu, 29 Oct 2015 06:10:22 GMT

If you load the updated conversion rate daily, it works. ... Somewhere, you have to provide qv the data, otherwise qv is not that intelligent . If you wish to input the data at the front end, you can do that too. In that case, you have to store the input in a variable and use that variable in the expression. Hope that makes sense.