topic Re: Funny characters appearing when exporting from Qlikview to Excel in QlikView

Funny characters appearing when exporting from Qlikview to Excel

Tue, 09 Jul 2013 09:25:35 GMT

Hi all,

When we export a document from Qlikview to Excel the "ï»¿" character appears in the CSV file.

It seems to appear after every 1000 record!

It seems to appear in big files rather than small ones. Could it be that Qlikview, when processing big datasets, is batching them in 1000 records and this is when this character gets added??

Has anyone had this issuse before ?

How to fix it?

Thanks.

Re: Funny characters appearing when exporting from Qlikview to Excel

Tue, 09 Jul 2013 10:31:48 GMT

It looks weird indeed. Did you contact support?

Re: Funny characters appearing when exporting from Qlikview to Excel

Gysbert_Wassenaar — Tue, 09 Jul 2013 10:50:34 GMT

I think that's a byte order mark, aka BOM. That means the csv file is utf-8 encoded. That could well be since afaik Qlikview exports csv files in utf-8 encoding. If you view the file in something that thinks the file is ascii you can get the funny characters. In editors like notepad++ you can change the encoding to ascii and then save the file.

Re: Funny characters appearing when exporting from Qlikview to Excel

Anonymous — Mon, 02 Sep 2013 13:56:45 GMT

We have the same issue with QV11 SR3. Could someone check it?

The Problem occurs with exporting via macro. But only if there are a lot of datasets (we have 300tsd).

Best regards

M.Gencsoy

Re: Funny characters appearing when exporting from Qlikview to Excel

rbecher — Mon, 02 Sep 2013 14:09:14 GMT

Yes, it's utf-8 byte order mark (BOM), usually it occurs at first in the file, just once. How you're doing the export?

Re: Funny characters appearing when exporting from Qlikview to Excel

andrespa — Tue, 10 Jan 2017 10:38:01 GMT

Hi Gysbert. This is happening to me on Qlik Sense as well. I've tried what you said but still have the same problem. Is very weird because it's not happening always, and it seems that the size of the data is not related to the issue. I'm thinking that it might be something on related to the sintax of the Store but not sure though. Any ideas on how to solve this?

Thanks,

Andrés