Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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
 its_anandrjs
		
			its_anandrjs
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		You can try this also
Year( DISTINCT Date(Date#([Ordered Date], 'DD/MM/YY hh:mm TT'),'YYYY') )
