Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
AH
Creator III
Creator III

Using different Currency options in dashboard

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 Data file has been added.

2 Replies
senpradip007
Specialist III
Specialist III

Your apps is running without data, hence please reload the same and re-upload it again.

AH
Creator III
Creator III
Author

Hi Pradip,

Can you see the QVW with data now?


The data excel file has also been added for convenience.

Thanks,

Shan