Money Format Problem

[jukah_do]

Hi all,

Something weird is happening and I cannot figure out why. I have two apps with the same Main script:

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 FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='de-AT';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan;Feb;Mär;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember';
SET DayNames='Mo.;Di.;Mi.;Do.;Fr.;Sa.;So.';
SET LongDayNames='Montag;Dienstag;Mittwoch;Donnerstag;Freitag;Samstag;Sonntag';

Then I have this section (again the same for both apps):

Load*Inline [
City,Spend
Zagreb,11.90
Oslo,123.90
Vienna,1234.90
Bratislava,12345.90
Budapest,123456.90
Berlin,1234567.90
Paris,12345678.90
London,123456789.90
Madrid,1123456789.90
]
(Delimiter is ',');

And when I format as money, the two apps show the number differently:

What's going on with the one on the right side I do not know... Qlik Sense Desktop September 2017, both apps created on the same PC. Can somebody explain what's happening here, this bugs me a lot.

Thanks

[jukah_do]

True, I changed one of the blank spaces with another whitespace character (U+2009) and it is ok now.

Still cannot understand why the other app that has the same blank spaces works properly.

Thanks!

[ToniKautto]

The problem with blank spaces is that they can be different ASCII characters, without any visible difference. My best guess is that the blank is different in the two scenarios.

Glad to hear you got it sorted out!