Format of a field value

[#1]

I am loading a field called "Group" directly from a website.  One of the values is "Open (20 – 39 yrs)", but Qlikview is interperting the equals sign ("=") to three very weird characters (a€“).  How do I correct this?

[swuehl]

I would personally prefer fixing the issue at the source, not the symptoms.

When I asked for the script snippet, I was actually asking for the complete LOAD statement, most interested in the part where you specifiy the source and the source format. I still assume specifying the source correctly would fix your issue with the dash (and potentially also other issues you just haven't noticed yet with the broken character set).

[#3]

CrossTable(Year, GroupPercent)

LOAD [Â ] as Group,

     [1980],

     [1995],

     [2000],

     [2005],

     [2010],

     [2011],

     [2012],

     [2013]

FROM

[http://www.runningusa.org/marathon-report-2014?returnTo=annual-reports]

(html, codepage is 1252, embedded labels, table is @1, filters(

[#4]

Changing it to UTF8 Character set fixed it perfectly!  Thanks!