November 2018 Release - Issue with Export to CSV

[santonien]

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!

[hopkinsc]

Hi,

How are you exporting to CSV?

Right click>Export?

[santonien]

Hi Hopkinsc,

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

Thanks in advance,

San 

[hopkinsc]

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

[mhallikainen]

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

[santonien]

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

[hopkinsc]

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. 

[santonien]

Hi @hopkinsc,

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

[santonien]

Hi @hopkinsc, @mhallikainen,

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

Cheers,

San