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?