topic Currency Problem in QlikView

Currency Problem

AH — Sat, 27 Jun 2015 12:48:37 GMT

Hi All,

I need to create a text box which calculates the Gross Revenue (Sum of Line Amount) for Transactional, Functional and Reporting Currencies.

but in one text box i would be able to switch between Currencies(Transactional, Functional and Reporting).

I have different Currencies(Transnational[ALL Currency], Functional[USD, GBP] and Reporting currency[USD].

Is there anyway you can help me with that? I would really appreciate your help.

Thanks,

AhmedTest - Copy.qvw

Re: Currency Problem

Anonymous — Mon, 29 Jun 2015 15:28:10 GMT

Does the attached give you food for thought ?

Re: Currency Problem

AH — Mon, 29 Jun 2015 15:39:28 GMT

Hi Bill,

Thanks for your reply. It looks great. I actually attached a sample copy of the data but need to apply that to the actual Dashboard and test the data if your provided attached file logic give me exactly what i need.

Again Thanks for your reply. I really appreciate it!

Thanks,

Ahmed