Currency issue using local - Â

[qliknerd]

Hi

I am bringing in some currency data during a QVD load and noticed an  character appearing in the columns.

Example:

SET ThousandSep

=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

let vG.BasePath=;
// Basic search for 1.Init.qvs
$(Include=..\..\..\..\3.include\1.basevariable\1.init.qvs);
$(Include=..\..\..\3.include\1.basevariable\1.init.qvs);
$(Include=..\..\3.include\1.basevariable\1.init.qvs);
$(Include=..\3.include\1.basevariable\1.init.qvs);
Exit script when '$(vG.BasePath)'= '';

// Locale example for UK English
//$(Include=$(vG.LocalePath)\3.UK.qvs);

LOAD
Money(F1) as F1;
LOAD * INLINE [
F1
3.15
2.50
3.83
210.3
2326.2
];

Results in this:

F1

£2.50
£3.15
£3.83
£210.30
£2326.20

However, if I remove the standard local and uncomment the QDF to include the UK file I get this output instead:

£2.50
£3.15
£3.83
£210.30
£2326.20

Anyone have the same issue?

Thanks

Ian

[Magnus_Berg · Accepted solution]

Hi Ian, and thanks for the info. Had a look at the problem. Seems that 3.UK.qvs was using a bad encoding, (UTF-8 without bom) changed to pure UTF-8 and it seems to work fine for me now. Replace with attached and try, this will be updated in next minor QDF release.

Regards Magnus

[qliknerd]

Thanks for the quick response Magnus, copied to all containers manually and worked a treat.