Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

List Box with dates

I have a list box with dates in the format of dd/mm/yyyy. I would like to be able to only show each year, ex: 2005, 2006, 2007, etc. only once. I would also like to do this for the months as well. If anyone could help I would greatly appreciate it.

1 Solution

Accepted Solutions
Not applicable

List Box with dates

You can create an expression directly in the list box :

Year(   yourDatefield)

Month(   yourDatefield)

weekday(   yourDatefield)  to get days Mon, Tue,...

JJ

2 Replies
Not applicable

List Box with dates

You can create an expression directly in the list box :

Year(   yourDatefield)

Month(   yourDatefield)

weekday(   yourDatefield)  to get days Mon, Tue,...

JJ

Not applicable

List Box with dates

Thank you!