topic Re: Display only weekdays on line chart in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Display-only-weekdays-on-line-chart/m-p/648605#M121 <HTML><HEAD></HEAD><BODY><P>Hi Roya, not sure of how is your data or if you have a date field, you can try set an if in expression like this:</P><P>If(<SPAN class="Bold">weekday(</SPAN><SPAN class="Italic">fecha</SPAN><SPAN class="Bold">)&lt;5, expression)<BR /></SPAN></P></BODY></HTML> Fri, 19 Sep 2014 11:32:11 GMT rubenmarin 2014-09-19T11:32:11Z Display only weekdays on line chart https://community.qlik.com/t5/Qlik-Learning-Discussions/Display-only-weekdays-on-line-chart/m-p/648604#M120 <HTML><HEAD></HEAD><BODY><P>We are creating a line chart using day a dimension and we would like to only display weekdays (Monday through Friday, not Sat and Sun). Is there a simple way to do this without deselecting the <SPAN style="font-size: 10pt; line-height: 1.5em;">"show all values" box and make a calculated dimension based on an if statement.</SPAN></P><P></P><P>Thank you!</P></BODY></HTML> Fri, 19 Sep 2014 11:16:19 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Display-only-weekdays-on-line-chart/m-p/648604#M120 2014-09-19T11:16:19Z Re: Display only weekdays on line chart https://community.qlik.com/t5/Qlik-Learning-Discussions/Display-only-weekdays-on-line-chart/m-p/648605#M121 <HTML><HEAD></HEAD><BODY><P>Hi Roya, not sure of how is your data or if you have a date field, you can try set an if in expression like this:</P><P>If(<SPAN class="Bold">weekday(</SPAN><SPAN class="Italic">fecha</SPAN><SPAN class="Bold">)&lt;5, expression)<BR /></SPAN></P></BODY></HTML> Fri, 19 Sep 2014 11:32:11 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Display-only-weekdays-on-line-chart/m-p/648605#M121 rubenmarin 2014-09-19T11:32:11Z Re: Display only weekdays on line chart https://community.qlik.com/t5/Qlik-Learning-Discussions/Display-only-weekdays-on-line-chart/m-p/648606#M122 <HTML><HEAD></HEAD><BODY><P>For Week End only use this dimension:</P><P></P><P><STRONG>=if(Num(WeekDay(xDate))&lt;5, WeekDay(xDate)) </STRONG>&nbsp;&nbsp; for labour week</P><P></P><P><STRONG>=if(Num(WeekDay(xDate))&gt;4, WeekDay(xDate)) </STRONG> for Week End</P><P></P><P>where xDate is your field DATE</P><P></P><P><IMG __jive_id="67198" alt="p01.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67198_p01.png" style="width: 620px; height: 301px;" /></P></BODY></HTML> Fri, 19 Sep 2014 11:43:21 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Display-only-weekdays-on-line-chart/m-p/648606#M122 ecolomer 2014-09-19T11:43:21Z