7 Replies Latest reply: Apr 22, 2016 3:46 AM by Sunny Talwar RSS

    Convert datetime serial number

    Johann Bauer

      Hi community,

      this is my first post so try to be gentle .

       

      I am new to qlik Sense and doesnt have any experience with qlik view so far.

      My problem is that I cant convert a datetime serial number into a date again:

       

      I am importing an excel file with a date format like 01.01.2106, it looks like qlik sense automaticly cast this format into his own

      datetime serial format. After the load i transform the table into crosstable my table looks like this:

      MonthNameDescriptionAmount
      42370Some Random Text10
      42401
      Some Random Text
      12

      Now I tried to load the resident table with some a converted date.

      My script looks like this:

       

      Load

      Date(MonthName) as Date, // also tried Date(MonthName,'DD/MM/YYYY') as Date

      Description,

      Amount

      Resident TempBudget ;

       

      But im only getting a empty column.

       

      I hope there is an easy way to do this.

       

      KR

       

      Johann