Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
AH
Contributor

Currency Problem

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

1 Solution

Accepted Solutions

Re: Currency Problem

Does the attached give you food for thought ?

2 Replies

Re: Currency Problem

Does the attached give you food for thought ?

AH
Contributor

Re: Currency Problem

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

Community Browser