4 Replies Latest reply: Nov 7, 2016 3:00 PM by Fei Xu RSS

    Date Value displays a null

    Ian Hughes

      All;

       

        I think that this is a very simple question but I cannot seem to identify the issue.

       

        I have an excel file that has several columns in it 2 of which are open date and closed date.

       

        I wanted to put the 2 dates into a table so I could then calculate the interval or the length of time to get to a close.

       

        The trouble I seem to be having is that the open date displays normally but the close date displays as null.  I cannot seem to determine why the close date displays as null.  The format of the column is  Date  and has the same type of data as the open date.

       

        Date Open                    Date Closed

      05/05/201530/06/2016
      18/08/201530/06/2016
      18/08/201530/06/2016
      18/08/201530/06/2016
      13/08/201512/07/2016
      13/08/201512/07/2016

       

      Here is the image from my qlik sense sheet

       

      2016-11-07_10-22-42.jpg

      Just to verify that the invoices displayed  have close values

       

        Invoice Number

      264249
      264249 

      date opened                    date closed

      13/08/201512/07/2016
      17/09/201529/03/2016

       

        Thanks in advance for any suggestions -   The  table values have no expressions just a display of the field value

        • Re: Date Value displays a null
          Kaushik Solanki

          Hi,

           

          Just one question, did you use the Date function while loading, like Date(Closed Date).

           

          If Yes then it is because the Value which you are getting from Excel is not in Date format, its a Text format.

           

          You can try this,

          1. Change the source. Go to excel and change the format of the Closed Date to Date format.

          2. You can use the Date#() function as below to convert text into Date.

               Date(Date#(Closed Date,'DD/MM/YYYY')) as ClosedDate

           

          Regards,

          Kaushik Solanki