10 Replies Latest reply: Oct 12, 2017 9:55 AM by Anand Chouhan RSS

    How to convert a timestamp column in Year YYYY format?

    Radhika Kotekar

      Hi,

      I tried using the YEAR() function but I am not getting any records.

       

      I imported an excel file in my qlikview and I wanted to extract year from a timestamp column, but I am unbale to do so.

      What could be the error?

       

      PFA screenshot

      I want to Year from the ORDERED DATE list box,

       

      for example

      2014

      2015

      2016

       

      Thanks