topic Re: Day Of Week in QlikView https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769889#M1040881 <HTML><HEAD></HEAD><BODY><P>WeekDay()</P></BODY></HTML> Wed, 03 Dec 2014 17:17:35 GMT MarcoWedel 2014-12-03T17:17:35Z Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769886#M1040869 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have list boxes for Year and Month. I would now like to create one for "Day of Week" containing "Monday" to "Sunday" as values.</P><P>What function can I use for this?</P></BODY></HTML> Wed, 03 Dec 2014 16:55:46 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769886#M1040869 2014-12-03T16:55:46Z Re: Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769887#M1040871 <HTML><HEAD></HEAD><BODY><P>There is a date mask to use.&nbsp; 'WWW' will return&nbsp; Mon,Tue, Wed.&nbsp;&nbsp; 'WWWW' will return the full word Monday, Tuesday...</P><P></P><P>Pass the 'WWW' mask to the function date() to render a date in this format.</P><P></P><P>=Date(Date,'WWWW')</P></BODY></HTML> Wed, 03 Dec 2014 16:58:20 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769887#M1040871 JonnyPoole 2014-12-03T16:58:20Z Re: Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769888#M1040880 <HTML><HEAD></HEAD><BODY><P>DayName(DateField)</P></BODY></HTML> Wed, 03 Dec 2014 16:58:22 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769888#M1040880 jpapador 2014-12-03T16:58:22Z Re: Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769889#M1040881 <HTML><HEAD></HEAD><BODY><P>WeekDay()</P></BODY></HTML> Wed, 03 Dec 2014 17:17:35 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769889#M1040881 MarcoWedel 2014-12-03T17:17:35Z Re: Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769890#M1040882 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan</P><P></P><P>Thanks for your answer. I have applied your method and now it shows a lot of random weekdays.</P><P>I would only like it to show Monday, Tuesday, Wednesday, Thursday, Friday, Saterday and Sunday.</P></BODY></HTML> Wed, 03 Dec 2014 17:18:29 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769890#M1040882 2014-12-03T17:18:29Z Re: Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769891#M1040883 <HTML><HEAD></HEAD><BODY><P>To get only one value per day of week in chronological order you could use:</P><P></P><P>=Dual(Date(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date</SPAN>,'WWWW'), WeekDay(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date</SPAN>))</P></BODY></HTML> Wed, 03 Dec 2014 17:26:08 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769891#M1040883 MarcoWedel 2014-12-03T17:26:08Z Re: Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769892#M1040885 <HTML><HEAD></HEAD><BODY><P>WeekDay returns an interger</P></BODY></HTML> Wed, 03 Dec 2014 17:34:46 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769892#M1040885 2014-12-03T17:34:46Z Re: Day Of Week https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769893#M1040886 <HTML><HEAD></HEAD><BODY><P>Does it?</P><P></P><P><IMG alt="QlikCommunity_Thread_144526_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/72655_QlikCommunity_Thread_144526_Pic1.JPG.jpg" /></P></BODY></HTML> Wed, 03 Dec 2014 19:22:47 GMT https://community.qlik.com/t5/QlikView/Day-Of-Week/m-p/769893#M1040886 MarcoWedel 2014-12-03T19:22:47Z