topic Group years in a List Box in QlikView

Group years in a List Box

Wed, 02 Jun 2010 19:17:12 GMT

Hello,

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.

fernandotoledo — Wed, 02 Jun 2010 19:31:08 GMT

See if your Date field is loaded as Text. In this way tou need to convert it in the script like

date#(Date_Field,'DD/MM/YYYY')

then the year () function will work

Wed, 02 Jun 2010 19:42:21 GMT

It worked just fine!

Thanks a lot!

Valeuu!

fernandotoledo — Wed, 02 Jun 2010 19:50:47 GMT

Blz Amigo!