9 Replies Latest reply: Jan 16, 2015 7:03 AM by neetha P RSS

    why the numbers under a date column is getting converted automatically to date

      Hi,

       

      I have an excel sheet with the below data and my requirement is to get the amount for the latest date according to the ERP ITEM Code

      am trying to do cross table and load the data in qlikview,but automatically the values under the date column are getting converted to date when I am loading as in the attachment.

      Can some one let me know how to get values under the date column .I have attached the excel sheet also.