German characters in text file

[nigel987]

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 &#228; but I still don't get it right.

Any suggestions how I could solve this?

KR,

Nigel

[swuehl]

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.

[nigel987]

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!

[swuehl · Accepted solution]

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

How can I use include files saved in UTF8

[nigel987]

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.

[Sri27]

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.