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.