topic List Box with dates in QlikView https://community.qlik.com/t5/QlikView/List-Box-with-dates/m-p/328013#M1183389 <HTML><HEAD></HEAD><BODY><P> Thank you!</P></BODY></HTML> Thu, 17 Nov 2011 20:30:17 GMT 2011-11-17T20:30:17Z List Box with dates https://community.qlik.com/t5/QlikView/List-Box-with-dates/m-p/328011#M1183387 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 17 Nov 2011 20:08:22 GMT https://community.qlik.com/t5/QlikView/List-Box-with-dates/m-p/328011#M1183387 2011-11-17T20:08:22Z List Box with dates https://community.qlik.com/t5/QlikView/List-Box-with-dates/m-p/328012#M1183388 <HTML><HEAD></HEAD><BODY><P>You can create an expression directly in the list box :</P><P>Year(&nbsp;&nbsp; yourDatefield)</P><P></P><P>Month(&nbsp;&nbsp; yourDatefield)</P><P></P><P>weekday(&nbsp;&nbsp; yourDatefield)&nbsp; to get days Mon, Tue,...</P><P></P><P>JJ</P></BODY></HTML> Thu, 17 Nov 2011 20:17:46 GMT https://community.qlik.com/t5/QlikView/List-Box-with-dates/m-p/328012#M1183388 2011-11-17T20:17:46Z List Box with dates https://community.qlik.com/t5/QlikView/List-Box-with-dates/m-p/328013#M1183389 <HTML><HEAD></HEAD><BODY><P> Thank you!</P></BODY></HTML> Thu, 17 Nov 2011 20:30:17 GMT https://community.qlik.com/t5/QlikView/List-Box-with-dates/m-p/328013#M1183389 2011-11-17T20:30:17Z