Discussion Board for collaboration related to QlikView App Development.
I have a data in google sheets and it is connected to Qliksense using connectors. There are few special characters in the data like Börse and getting the data in Qliksense as B~A?se . Kindly help me out how to handle this kind of data loading from google sheets.
output should be:
Solved! Go to Solution.
I'm not sure which version of the Qlik Web Connectors you are using, but could you please try the latest version (November 2017, Patch 2) because an issue with character encoding for Google Spreadsheets was fixed in a patch earlier this year (Patch for Qlik Web Connectors November 2017 Release Available).
If you still have issues with the latest version, please let me know.
so if you know the characters you can try what Chanty said Keepchar fucntion like this
keepchar(field,'~!@#$%^&*()_+') as Yourfield
Thank you, Mayank. I tried the keep char function, I am getting the blank data in that field. Kindly check the below function and let me know the solution.
keepChar([Global Customer Name], 'Ö') as [Global_Customer_Names]