8 Replies Latest reply: Jul 24, 2018 9:35 AM by Eric LAI RSS

    Data (Date information) Lost When Loading data from Excel

    Eric LAI

      When I try to load data from an Excel File, I just find that some data are lost after loading the data. To be exact, some columns containing the date and time information cannot be selected into Qlik Sense and cause a lot of errors in the final visualizations.

       

      As seen the two graphs from below, the first graph is the data loaded in Qlik Sense and the second is the original file in Excel. Obviously, the first and third line of Submission Time is not loaded into Qlik Sense. This will lead to a null value in the later charts created.

      Image1.JPG

      image2.JPG

      I am wondering if it is because of the date formats of excel and Qlik Sense are inconsistent. I am very confused about that. Can anyone tell me how to fix it? Many thanks!