Read '€' special character from .xlsx file

[cgxanth21]

Hello all,

I am trying to load data from an .xlsx file in Qlik Sense. I am experiencing issues with cells that includes '€' special character.

For example if a cell has the value 'We have to pay 20 euro (20€)' , qlik sense only loads ')' and ignores the whole sentence before €.

Thanks in advance!

G.

[hajastek · Accepted solution]

Hi all,

I have tried to help George with this issue.. We have applied text() function and some other text operations like Mid, Subfield etc. and It always looked like there was only ')' in the data source, although there is a full sentence with finishing ...€). Also Len() function returns 1 as a result for that specific cell. The source excel file is export from some oracle system and once we open it and save with no performed change everything is working correctly.

Unfortunately we are not able share an excel file/QVF and I was not able to simulate this behavior on my personal computer with the newest Qlik Sense November release either.

Thanks for any comments or idea.

[mboulkhir]

Hello,

I ve the same problem and when i open the file and save it with no performed change, everything woks.

Did you solve the problem without open and save the file manually ?

Thank you !