Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Aug 25, 2021 3:34:44 PM
Feb 19, 2019 9:13:26 AM
QlikView, versions November 2018 and above
In QlikView, November 2018 release and later, the Export to Excel CSV format may result in the fields being separated by a semicolon instead of a comma.
QlikView November 2018 introduced the use of International Components for Unicode (ICU) libraries. More information regarding ICU libraries can be found in the online QlikView Help.
QlikView May 2021 has a defect (ID ID QV-22407) that affects the parameter mentioned in the resolution below, so if the resolution was applied on a previous version, the issue resurfaces on May 2021.
Note: The resolution applies only to versions prior May 2021, in which a defect was found (ID QV-22407) which affects the resolution below.
This issue is typically resolved by editing the QlikView Server Settings.ini file and entering UseIcuForLocaleInfo=0
Please see the below steps on how to include this setting:
Also, be sure that the comma is set as List Separator in your operating system regional settings. To do this:
See the image below. Note in the Customize Format screen that the List separator is set as a semi-colon ";" therefore it would need to be changed to a comma ",". When making changes to these values, a reboot of the server is necessary.