Special Characters in Qlikview

Mon, 16 Mar 2015 17:34:51 GMT

Hi,

I have a problem with special chars like "ñ" or "Á" that appear with "?".
The problem exists when I download data into qvd.
Data is downloaded into qvds, from Oracle database.In Oracle database, data is correct.

I don´t want to remove or skip special chars.

There Exists some setting to set the encoding to UTF-8? or I have to use some pl/sql function to bring the correct data into qvd.

Thanks in advance.

Greetings.

Rodrigo E.

Re: Special Characters in Qlikview

jaspsing — Mon, 18 Jan 2016 19:41:18 GMT

Hello ,

I know it's so much old post, but searching through the post for some problem your post give an idea and here is the solution.

you can use ApplyCodePage on that field and apply UTF-8 as 10000.

Ex:

ApplyCodePage(Field,10000) as NewField

All your hidden or special character will start appearing.

Thanks

topic Special Characters in Qlikview in QlikView

Special Characters in Qlikview

Re: Special Characters in Qlikview