11 Replies Latest reply: Nov 14, 2017 5:19 PM by Toni Kautto RSS

    Money Format Problem

    jukah doanart

      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:

      Capture.PNG

       

      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