7 Replies Latest reply: Aug 4, 2015 3:21 AM by Marcus Sommer RSS

    Can not use Year(xxx) as Year

    Peter Svendsen

      Dear all,

       

      I'm new within QlikView and are testing the application.

      I have tried to load with the following script

       

       

      ...................

      SET DateFormat='MMM DD, YYYY';

      ................... 

      LOAD [No. (Ticket)],
                     [Department (resp.)],
                     [Created Date],
                     Year([Created Date]) as Year,
                     Month([Created Date]) as Month,

      ...................

       

      my .xls file contain the coulmb Create Date e.g with the following date Jul 22, 2015

       

      When I reload my data all goes well but the month and year are always empty... why is that?

       

      Another question, is there a Quarter() function as well so I can convert a date to a quarter? I'm not able to locate it?

       

      Thanks in advance

      Peter