6 Replies Latest reply: Jul 27, 2012 5:29 AM by Dimitris Charalampou RSS

    converting number into money format

      HI there,

       

      i am loading some data to my qlikview project and from a .dat file. Because of this the format of the fields are prespecified and cannot be changed.

      I have a field that contains money data and has values like: 00000001005 ( for 10,05 $), 00000002030 ( for 20,30 $) etc etc.

       

      How can i convert them into the correct format ( eg 10,05 $)?

       

      Thank you in advance for your answers.