Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Multiple Currency Conversion Issue?

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

1 Solution

Accepted Solutions
pooja_prabhu_n
Creator III
Creator III

Hi,

try using below expression

=Sum(Amount/PDR)

View solution in original post

2 Replies
pooja_prabhu_n
Creator III
Creator III

Hi,

try using below expression

=Sum(Amount/PDR)

Anonymous
Not applicable
Author

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