topic Re: ApplyCodepage in App Development

ApplyCodepage

Aubry — Mon, 07 Feb 2022 13:20:17 GMT

Hello all,

characters underlined in yellow are not correct :
I apply the Apply Code page function in a "dimension" to display the correct characters, but it does not work
- dimension is : =ApplyCodepage(informationsComplementaires,1252 )

thank you for your help

have e good day

Re: ApplyCodepage

chris_djih — Mon, 07 Feb 2022 15:06:27 GMT

1. Are you loading from a Escel/ CSV or form a database conection?

2. Often the codepage problem already occurs in the data source, Please check if the data source display the correct values.

Re: ApplyCodepage

Aubry — Mon, 07 Feb 2022 15:42:11 GMT

Thank you for answear,

only loading a database conection,
the values in the datasource are not correct :

Re: ApplyCodepage

chris_djih — Tue, 08 Feb 2022 09:28:24 GMT

Then you have to fix it there. There is saying that fits quite well: garbage in - garbage out.

So this isn't a problem with qlik and can't be fixed within qlik.
(except you can reenginieer which codepage format conflict came from the DB and than replace the format codes like "&e" and "e;" with the real symbols)

Re: ApplyCodepage

Aubry — Thu, 10 Feb 2022 07:24:36 GMT

Hello, thank you very much for your answer.
I will set it up
have a good day
AUbryb M