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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Reply
whiteline
Master II
Master II

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.