topic Re: Switching between Currencies in a Text box in QlikView

Switching between Currencies in a Text box

AH — Wed, 24 Jun 2015 01:54:16 GMT

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

Re: Switching between Currencies in a Text box

settu_periasamy — Wed, 24 Jun 2015 02:18:55 GMT

Hi,

Can you give the example for this?

Re: Switching between Currencies in a Text box

Anonymous — Wed, 24 Jun 2015 02:51:25 GMT

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

Re: Switching between Currencies in a Text box

settu_periasamy — Wed, 24 Jun 2015 03:02:06 GMT

Have you tried with cyclic Group?

Find the attachment. Maybe help ful.

Re: Switching between Currencies in a Text box

Chanty4u — Wed, 24 Jun 2015 03:33:59 GMT

PFA

Thank you

suresh

Re: Switching between Currencies in a Text box

AH — Thu, 25 Jun 2015 14:32:53 GMT

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