Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Loading from QVS using $(Import=...) causes "€" to become "€"

See attached QVW and QVS.

Download both to the same directory and reload.

Notice how this SET in the QVS file:

SET vCurrency = '€';

Becomes this in the variable window after load:

€

load with euro.PNG

I think this is an encoding problem.

encoding issue in notepad.png

I think I cannot "set" the encoding  of my QVS file. Even if Notepad++ "tells me" it is encoded in UTF-8 Qlikview could not "detect" its encoding by reading the file alone.

Is there a way I can "instruct" Qlikview what kind of encoding to use?

When put the SET expression into the "builtin" load script in the QVW, (i.e. I don't Import anything) it works fine.

Tags (2)
1 Solution

Accepted Solutions

Re: Loading from QVS using $(Import=...) causes "€" to become "€"

You have to use the BOM header when using UTF8 in an include file. Use "Encode in UTF-8-BOM" from your Notepad++ Encoding menu.

See

How can I use include files saved in UTF8

And don't forget to search the Forums

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

3 Replies

Re: Loading from QVS using $(Import=...) causes "€" to become "€"

You have to use the BOM header when using UTF8 in an include file. Use "Encode in UTF-8-BOM" from your Notepad++ Encoding menu.

See

How can I use include files saved in UTF8

And don't forget to search the Forums

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Not applicable

Re: Loading from QVS using $(Import=...) causes "€" to become "€"

Thanks. Either I didn't search at all or didn't use the right terms. "Delete as duplicate"?

At least some could see that the BOM is an option in the Notepad++ UI, in my screenshot --

And this means that  my statement is wrong:

Even if Notepad++ "tells me" it is encoded in UTF-8 Qlikviewcould not "detect" its encoding by reading the file alone.

Others:

Bug? Nordic (æøå) characters garbled using $INCLUDE and UTF-8 encoded .qvs

How can I use include files saved in UTF8

Re: Loading from QVS using $(Import=...) causes "€" to become "€"

‌i don't always get great results when using the search box here. I get better results using google with a site keyword. Eg

include utf8 site:Qlik.com

-Rob

Community Browser