Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hbleby96
Contributor II
Contributor II

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)

hbleby96
Contributor II
Contributor II
Author

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