Discussion Board for collaboration related to Creating Analytics for QlikView.
I need help to use the year from my date collum. I have a date format like DD/MM/YYYY.
I'm having some problems to show only the year (such 1999, 2000) in my list box.
I have just reached a point that shows me 01/01/2001,01/01/2002.... But I need to see only the YYYY.
I've tried YEAR(), LEFT(), RIGHT(), but nothing worked.
Anyone have idea how to show only the year?
If it's does't clear enough, please be welcome to ask and I'll try to explain in other way.
Thanks a lot.
Go to Solution.
See if your Date field is loaded as Text. In this way tou need to convert it in the script like
then the year () function will work
It worked just fine!
Thanks a lot!