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:
Stop the QlikView Server Service (QVS) on all nodes running QVS
Open a text editor such as Notepad++ as with administrator privileges
Navigate to the QlikView Server Settings.ini file in %ProgramData%\QlikTech\QlikViewServer
Add UseIcuForLocaleInfo=0 underneath the [Settings 7] section. ***Please note that if the setting is added under the [Authentication] property, it will not be read by the QlikView Server Service.***
Save the Settings.ini file
Restart the QVS nodes
Also, be sure that the commais set as List Separator in your operating system regional settings. To do this:
Log on to the QlikView server as the QlikView service user
Open the Control panel and go to "Regional"
Click on the "Additional Settings..." button in the "Formats" window
Choose the correct list separator
Restart the machine
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.