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 !