Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Honored Contributor II

Re: Loading in excel info that is in multiple currencies

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.

Community Browser