topic Re: Currency Conversion, to multiple choices in QlikView

Currency Conversion, to multiple choices

marcus_steggall — Fri, 13 Nov 2015 11:45:36 GMT

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.

Re: Currency Conversion, to multiple choices

Gysbert_Wassenaar — Fri, 13 Nov 2015 14:08:43 GMT

See attached example. Does that do what you want?

Re: Currency Conversion, to multiple choices

Kushal_Chawda — Fri, 13 Nov 2015 14:13:47 GMT

Please see the attached

Re: Currency Conversion, to multiple choices

settu_periasamy — Fri, 13 Nov 2015 14:48:51 GMT

Another One..

Re: Currency Conversion, to multiple choices

marcus_steggall — Mon, 16 Nov 2015 13:00:57 GMT

thanks for the replies everyone

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

Have a great day