Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to convert a timestamp column in Year YYYY format?

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

10 Replies
its_anandrjs
Champion III
Champion III

You can try this also

Year( DISTINCT Date(Date#([Ordered Date], 'DD/MM/YY hh:mm TT'),'YYYY') )