topic Re: Using different Currency options in dashboard in QlikView

Using different Currency options in dashboard

AH — Thu, 11 Dec 2014 04:05:32 GMT

Qiuck response is highly appreciated!

I have to make the dashboard which will be filtered based on currency. Consolidate dashboard based on currency.

For example, I have LineAmount and TotalLineAmount which are Transactional Currency----(CurrencyCode in the Table)

I Have LineAmountInFunCurrency and TotalLineAmountInFunCurrency which we get after multiplying the ExchRate(in the table).

I have LineAmountInUSCurrency and Total LineAmountInUSCurrency which will indicate the Global currency view.

My requirement is:

1. Include all currency options in the dashboard based on (Using set analysis) make filters
a)Transactional
b)Functional
c)US Dollar (Global)

2. Add Mutiple tables with different currency.

I would really appreciate your cordial help.

Regards
Shan

Message was edited by: Shan Ahmed

Message was edited by: Shan Ahmed Excel Data file has been attached.

Re: Using different Currency options in dashboard

vikasmahajan — Thu, 11 Dec 2014 06:39:18 GMT

PFA Sample May help you

Vikas

Re: Using different Currency options in dashboard

Thu, 11 Dec 2014 08:00:07 GMT

Try this. Labels are out of place, never mind. Use list box to filter exchange rates and that will bring the values corresponding to those exchange rates for tables.

Re: Using different Currency options in dashboard

AH — Thu, 11 Dec 2014 13:20:23 GMT

Hi Eddie,

Thanks for your great help. Really appreciate this! Is it possible that when i click any currency in the Currencycode list box tt will also populate in the TotalLineAmountInUSD table as well by converting(using the exchange rate) ?

Please suggest.

Thanks,

Shan