5 Replies Latest reply: Sep 12, 2012 4:43 AM by Christian Bergeret RSS

    SAP Characteristic value format issue

      Hello All,

       

      I am retrieving the SAP material characteristics value from AUSP table from field ATWRT for CHAR and ATFLV for NUM and DATE.

       

      The problem is that Qlikview is displaying date like 2,0120822000000000E+07 (for 2012-08-22) and same kind of exp format for numeric values.

       

      Is there a magic function ;-) to transform  the format, either in script extraction or in the graph itself to display the right value ?

       

      Many thanks for your support !

       

      Christian