Multiple Currency Conversion Issue?

[Anonymous]

Hi,

I'm quite new to Qlikview and learning as I go along so I'm sorry if this is really obvious.

I have a Qlikview where the data I bring in is in Local Currency but the Qlikview needs to be in USD. I have therefore added a PDR rate file to convert the values which works perfectly when working with one currency. But if I then make a chart that requires multiple currencies converting to USD together, it doesn't work. I've attached an example. Is there a way around this as I really need to be able to use all 5 currencies converting into USD.

Similarly, when making a table, the total will not calculate if there are multiple currencies but works fine if I filter just for one currency companies etc.

Thank you in advance

[pooja_prabhu_n · Accepted solution]

Hi,

try using below expression

=Sum(Amount/PDR)

[Anonymous]

Thank you so much that worked! Seems so obvious now!!