Qlik Cloud Problem with ä

[SonPhanHumanIT]

Hello,

I’m facing an issue with a script that has sections stored as .qvs in SharePoint. These sections are retrieved using a MUST_INCLUDE command. The script works perfectly on-premises, but in the cloud, I’m encountering a problem where certain umlauts (ä, ü, ö) are not interpreted correctly.

Does anyone have a idea how to fix this problem?

Best regards Son

[JandreKillianRIC]

Hi @SonPhanHumanIT 

Have you tried putting this around those? 

IE [ and ] 

like [POS_Ländercode] 

Regards - Jandre

[SonPhanHumanIT]

Hi,

good point, i have test it but it doesnt work...

Best regards Son

[JandreKillianRIC]

Hi @SonPhanHumanIT 

This works on my side > Qlik Cloud. 

This is a QVD though... Don't know if that is where the error comes from. Just tried to replicate the issue on my side. 

[SonPhanHumanIT]

Hi,

Yes, this works for me as well, but i think, we're currently experiencing an issue with the SharePoint connector. 

Best regards Son

[JandreKillianRIC · Accepted solution]

Hi @SonPhanHumanIT 

Try this. 

Verify that your .qvs files are saved with UTF-8 encoding (preferably without BOM).(You can verify this using a Notepad++ or other code editors) 

and add this to your Global Variables 

SET ScriptCollationLocale='utf8';

[Daniele_Purrone]

Hi @SonPhanHumanIT : do you also have the issue if you put the script files somewhere else (dropbox, etc.)? Just to rule out that it's not a problem specific to the Sharepoint connector.

[SonPhanHumanIT · Accepted solution]

Hi,

Thank you, it worked! I changed the encoding to UTF-8 in Notepad. In the process, every "ä" was converted to "r4X". I manually corrected them back to "ä" and saved the file. That solved the issue.

Best regards Son

[JandreKillianRIC]

Hi @SonPhanHumanIT 

Awesome news!!! 

Happy Qlikking!