9 Replies Latest reply: May 24, 2017 4:02 AM by Andrey Khoronenko RSS

    Number Formatting Issue in Script

    Crystle Stamper

      I am creating a document that has a table which is replacing an excel report that a department currently gets daily.

       

      I need to have the table in Qlikview, formatted to the way they are used to seeing it in the daily Excel report and I am trying to accomplish this formatting in the script so I do not have to repeat it in each table it is used in, in the Qlikview document

       

      The problem is, I can't seem to match the format. See table below for example.

       

      The values need to only go out to 3 spaces after the decimal point, but ONLY if it has values for those three spaces (see how Items "ACB" and "AEB" have values after the decimal but not 3 spaces out so it shortens it to either 2 or 1 spaces)

       

      Then if the value is 0, it just needs to be "0", not "0.000".

       

      I tried using this format below but it did not give me the results I wanted.

      Num(ItemReq, '###0.###')

       

      Is this even possible in Qlikview?

       

      ItemItem Requirements
      ABC2347
      ABD0
      ADE

      1000.523

      ACB75.48
      AEB158.2