I am working on reading an xml file into my Qlikview App and the data contains special characters such as the ç and the registered trademark symbol. When trying to load these values into the Qlikview App, I am getting a message of:
An invalid character was found in text content.
On line number: 26. On column number: 2070.
Is there a way of handling these special characters when reading data from an xml file?
The only way I could get Qlikview to read the file was by changing the character set from utf-8 to windows-1252 in the xml file. It looks like some of the characters which were in the xml file were not utf-8 compliant.