topic Re: November 2018 Release - Issue with Export to CSV in QlikView

November 2018 Release - Issue with Export to CSV

santonien — Thu, 06 Dec 2018 01:00:27 GMT

Hi,

I just upgraded Qlikview from Nov 2017 to Nov 2018, and 'Export to CSV' now has delimiter as semicolon instead of comma as below, which causes Excel not renders the output properly. I wonder if anyone experiences the same issue, and know how to change delimiter back to comma? Thank you!

Re: November 2018 Release - Issue with Export to CSV

hopkinsc — Thu, 06 Dec 2018 10:05:47 GMT

Hi,

How are you exporting to CSV?

Right click>Export?

Re: November 2018 Release - Issue with Export to CSV

santonien — Thu, 06 Dec 2018 23:43:36 GMT

Hi Hopkinsc,

I view the app on Ajax client, and yes Just Right Click - Export.

Thanks in advance,

San

Re: November 2018 Release - Issue with Export to CSV

hopkinsc — Fri, 07 Dec 2018 09:06:17 GMT

I have just upgraded my version from Nov 2017 (where the delimiter was comma) to Nov 2018 and the delimiter is still a comma...

Re: November 2018 Release - Issue with Export to CSV

mhallikainen — Mon, 10 Dec 2018 03:52:35 GMT

Funny,

With Santonien,

Windows Server 2012r2 states list separator being "," (comma) in Regional settings and in RegEdit
Also, PowerShell command returns comma:

PS H:\> (Get-Culture).TextInfo.ListSeparator
,

One notable change is that double quotes have disappeared from the .csv file.
Is there an option to force comma as a field delimiter?

Cheers,
Marko

Re: November 2018 Release - Issue with Export to CSV

santonien — Mon, 10 Dec 2018 04:05:26 GMT

Hi Hopkinsc,

Did you test with published app on web server (Ajax Client). Coz when I export within Qlik IDE, it will be comma separated, as there will be an option to choose, but not when the app is viewed on the web.

If it works for you. Do you mind sharing some common attributes in setting.ini file please?

Thanks in advanced,
San

Re: November 2018 Release - Issue with Export to CSV

hopkinsc — Mon, 10 Dec 2018 08:30:29 GMT

Hi @santonien,

Where are you seeing an option to choose the delimter from the client?

I have tried from only the client, i will publish the QVW and try from a web server shortly though and let you know the results.

Re: November 2018 Release - Issue with Export to CSV

santonien — Mon, 10 Dec 2018 23:10:10 GMT

Hi @hopkinsc,

Please see screenshots below for Export functionality between Client Tool vs Ajax Client.

Re: November 2018 Release - Issue with Export to CSV

santonien — Tue, 11 Dec 2018 00:11:30 GMT

Hi @hopkinsc, @mhallikainen,

FYI, I just added UseIcuForLocaleInfo=0 into Setting.ini file, and it seems to solve the problem.

Cheers,

San