Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
AH
Creator III
Creator III

Switching between Currencies in a Text box

Hi All,

I need to create a text box which calculates the Gross Revenue (Sum of Line Amount) 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 anyone can help me with that? I would really appreciate your help.

Thanks,

Ahmed

5 Replies
settu_periasamy
Master III
Master III

Hi,

Can you give the example for this?

Anonymous
Not applicable

May be you can have 3 text boxes/ buttons and actions to select currency !!

settu_periasamy
Master III
Master III

Hi

Have you tried with cyclic Group?

Find the attachment. Maybe help ful.

Capture.JPG

Chanty4u
MVP
MVP

Hi

PFA

Thank you

suresh

AH
Creator III
Creator III
Author

Hi settu_periasamy,

Is it possible, when i select transactioanl currency then only the Gross revenue in Transactional currency text box will show value and Gross revenue in Functional and Reporting currency will show no value.

Again, if i select Functional Currency then only  Gross revenue in Functional currency text box will show value and Gross revenue in Transactioanl and Reporting currency will show no value.

Likewise.

Thanks for all the help.

Ahmed