topic German characters in text file in QlikView

German characters in text file

nigel987 — Tue, 24 May 2016 08:25:36 GMT

Hi,

I am defining a variable in a text file which I load into QlikView. The variable uses Set Analysis and contains a German special character (the word Verträge).

SET eAbgelaufenen = (Count({1<

OrganisationStatus={'Active'},

Vertragstyp={'Abgelaufene Verträge'}

>}Distinct OrganisationID));

I tried to replace it by Chr(228) and ä but I still don't get it right.

Any suggestions how I could solve this?

KR,

Nigel

Re: German characters in text file

swuehl — Tue, 24 May 2016 09:01:38 GMT

What's your exact issue? Does the variable in the front end not show up correctly?

I justed tested your code and it seems to work fine for me.

Re: German characters in text file

nigel987 — Tue, 24 May 2016 09:10:15 GMT

Hi,

did you read the expression from a text file? I've attached the sample text file and the qvw which loads the file.

After reload, the variable is displayed as

(Count({1<

OrganisationStatus={'Active'},

Vertragstyp={'Abgelaufene VertrÃ¤ge'}

>}Distinct OrganisationID))

Is it clear now? Did you need more information?

Thank you!

Re: German characters in text file

swuehl — Tue, 24 May 2016 09:23:11 GMT

You need to save your text file as UTF8 with BOM.

How can I use include files saved in UTF8

Re: German characters in text file

nigel987 — Tue, 24 May 2016 10:57:47 GMT

Thanks!

Saving the text file as "UTF-8" (instead of UTF-8 without BOM) was the solution.

For people having the same issue. I use Notepad++ and in the "Kodierung" tab you need to switch to UTF-8 before saving it.

Re: German characters in text file

Sri27 — Thu, 01 Sep 2022 13:47:25 GMT

I have similar situation, where the company name comes in QVX file, some company names has umlauts: Ä, Ö, Ü and ß. These umlauts are being displayed as ? in QlikView dashboard. (Version 12.6 May 2021 SR2).

Any suggestion to display these as expected would be a great helpful.