8 Replies Latest reply: Jul 26, 2017 4:53 PM by Marcus Sommer RSS

    Number formatting in document properties

    Rudolf Linder

      For a couple of fields we change the Default Format "mixed" to whatever we need in "Setting Document Properties\Numbers".

      From time to time these Settings are lost and the mixed format is defined again for these fields.

      As it is not possible that our team changes these settings, does anybody knows about any circumstances how this may happen?

      Our customer then complains that the numbers again are wrong (e.g. 60000 instead 60.000).
      As we have a lot of fields it would be a cumbersome job to control the fields which require another format than mixed.

      And even then we don't know when and where it happens that the format changes again.

      We are using Qlikview 11.20 SR 12 (soon we migrate to Qlikview 12). On Server we use Publisher in same Version.


      Any thoughts?



        • Re: Number formatting in document properties
          Anil Samineni

          Rather changing the default number format, Why can't we go Num() for the data points??

          • Re: Number formatting in document properties
            praveen A

            once check with the variable


            SET MoneyThousandSep=',';

              • Re: Number formatting in document properties
                Rudolf Linder

                my settings are defined, nethertheless I Need to overwrite some field settings


                // Standard-QV-Formateinstellungen

                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;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

                SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

              • Re: Number formatting in document properties
                Marcus Sommer

                AFAIK if a field don't contained only numeric fieldvalues it will be treated as "mixed" format. A single fieldvalue which has a different format respectively not correct interpreted format or maybe is missing or NULL could be enough. But normaly should a defined formating not change whereby I'm not sure what happens if there are scenarios where this field isn't loaded (completely) maybe by some testings or load-errors without canceling or maybe a load without data.


                I won't say that I haven't had this case but at moment I don't remember one so that I'm sure it's rather a rarely occurance whereby this isn't very helpful for you.


                If you couldn't find a reasonable explanation with the above hint of uncompleted loadings I would try to secure that the field is always filled and numeric maybe with some if-loop or an alt-function like alt(field, 0) as field. Further I could imagine to keep this field always pure numeric without any formatting like 42942 instead of 26.07.2017 and defining all formatting within the document properties.


                - Marcus