Discussion board where members can get started with QlikView.
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.
Go to Solution.
You can create an expression directly in the list box :
weekday( yourDatefield) to get days Mon, Tue,...