Currency Conversion, to multiple choices

[marcus_steggall]

Morning everyone,

Have been playing around with many ways of converting currency in qlikview, even using some of the techniques already posted by various people here in the community.

But I can't seem to find the one technique, that helps me get to an easiest process.

I've attached a quick excel file, showing what I'm trying to do.

Basically, you have a list box with the various current options.and when selected, the amont local wil convert into the chosen currency amount.

There is a conversion rates sheet, per period for this to drive off.

I've seen many examples, but can't quite understand the best process to get this working.

Any advice or suggestions to point me in the right direction, would be much appreciated.

[Gysbert_Wassenaar]

See attached example. Does that do what you want?

[Kushal_Chawda · Accepted solution]

Please see the attached

[settu_periasamy]

Another One..

[marcus_steggall]

thanks for the replies everyone

Really appreciate the advice and techniques, this has helped to achieve the end result.

Have a great day