Can you have a dynamic Currency Format in Chart Objects?
I have a Qlikview Document that has a 'dynamic' currency calculation.
i.e. The User can choose which currency to view their sales data in and the Expression Formula contain a calculation that multiplies the sales value by a conversion rate.
The only snag is that the charts are still displaying the default currency formatting.
Is there a way of making the Money Format change when the new currency is selected?