Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aj0031724
Partner - Creator
Partner - Creator

Chinese Characters to load in qlikview Dashboard

Dear Team,

WE have one Chinese client recently and they would going to share some of the data(tab delimedted file ) in Chinese characters .

Can you please advise  if qlikview is able to supports CHINESE CHARACTERS and if it required any changes during fetching of  these files inside qlikview script.

Also where GUI would be able to show those CHINESE CHARACTERS .

Please guide.

3 Replies
settu_periasamy
Master III
Master III

Hi,

If you tab delimited file saved as in Unicode (UTF-8), you can Load the data normally.

Capture.JPG

Script

LOAD Month,
[Trader Code],
[Chinese Importer Name CN]
FROM
sample_chinese.txt
(
txt, utf8, embedded labels, delimiter is '\t', msq);

sample attached..

aj0031724
Partner - Creator
Partner - Creator
Author

Dear Settu,

Thanks for the above response.

Till date all the file format WERE NORMAL tab delimeted txt file .And in the qlikview script we are using as below:

Files:

LOAD *,

FROM $(File)

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

This code is common across all the clients .Now how would I dynamically change the codepage to utf8 as you suggted above to handle Chinese characters specific for one clinet only?

How can I judge that file is in UTF8 or 1252 codepage?

pLEASE GUIDE.

marcus_sommer

UTF-8 files could be identified per BOM (Byte Order Mark) and here is a method to read this:

Re: Load CSV files with different format

- Marcus