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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RichardLee
Creator
Creator
‎2022-05-18 07:40 AM

Exchange Rates

 have an Exchange rate table in Qlik

RichardLee_0-1652873792129.png

 

and a table of data

RichardLee_2-1652873984854.png

 

 

How can I get the correct Exchange rate for the Actual Cost?

 

 

Labels (4)
Labels
733 Views
1 Solution

Accepted Solutions
RichardLee
Creator
Creator
‎2022-05-19 05:08 AM
Author

I figured out how to do this I unpivoted the Rates and did a left join on the Data.

View solution in original post

679 Views
2 Replies
vinieme12
Champion III
Champion III
‎2022-05-19 03:05 AM

please post some sample data

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
695 Views
0 Likes
RichardLee
Creator
Creator
‎2022-05-19 05:08 AM
Author

I figured out how to do this I unpivoted the Rates and did a left join on the Data.

680 Views