Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Group years in a List Box

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.

1 Solution

Accepted Solutions
fernandotoledo
Valued Contributor

Group years in a List Box

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

3 Replies
fernandotoledo
Valued Contributor

Group years in a List Box

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

Not applicable

Group years in a List Box

It worked just fine!

Thanks a lot!

Valeuu!

fernandotoledo
Valued Contributor

Group years in a List Box

Blz Amigo!