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 Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
Not applicable
‎2012-08-30 10:53 AM

Loading in excel info that is in multiple currencies

Hello, I have quite a simple file, but it is numerical information that is in multiple currencies (eg, sales in Taiwan are in TWD, in US are in USD, in UK are in GBP). I want the different currecies to be visible in Qlikview.

I have just started using Qlikview, but I can't seem to find a way to upload teh data in teh currency that excel holds the data in. Any ideas?

Cheers

329 Views
0 Likes
1 Reply
whiteline
Master II
Master II
‎2012-08-30 11:26 AM

In excel this data is likely stored as a number format.

Try to add these data into separate column if you can and then use load it in qlikview.

257 Views
0 Likes