topic Re: Weekstart day result is not getting as expected in QlikView https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3476#M791589 <HTML><HEAD></HEAD><BODY><P>I am loading only Nov , Dec and Jan till date data.</P></BODY></HTML> Fri, 19 Jan 2018 08:45:30 GMT krishna20 2018-01-19T08:45:30Z Weekstart day result is not getting as expected https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3474#M791587 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I am trying to create a weekstart days for all months and Monday is starting day of week.</P><P>But I am not getting result as expected and getting additional days .</P><P>The highlighted Mon-27th is belongs to Oct month in calendar. But, it's falling under Nov Month.</P><P>I haven't loaded Oct month data in my app.</P><P></P><P>PFB script and screenshot and advise.</P><P>Num(Month(Master_Date))&amp; '-' &amp; Day(weekstart(Master_Date,0))&nbsp; as ACDWeekMonth</P><P><IMG alt="Community.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190622_Community.PNG" style="width: 620px; height: 295px;" /></P><P></P><P>Thanks </P><P>Krishna</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3474#M791587 krishna20 2020-11-25T16:16:04Z Re: Weekstart day result is not getting as expected https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3475#M791588 <HTML><HEAD></HEAD><BODY><P>Maybe you have more than one year in your data?</P></BODY></HTML> Fri, 19 Jan 2018 08:44:17 GMT https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3475#M791588 jonathandienst 2018-01-19T08:44:17Z Re: Weekstart day result is not getting as expected https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3476#M791589 <HTML><HEAD></HEAD><BODY><P>I am loading only Nov , Dec and Jan till date data.</P></BODY></HTML> Fri, 19 Jan 2018 08:45:30 GMT https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3476#M791589 krishna20 2018-01-19T08:45:30Z Re: Weekstart day result is not getting as expected https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3477#M791590 <HTML><HEAD></HEAD><BODY><P>Can anyone show light on this issue.</P></BODY></HTML> Fri, 19 Jan 2018 09:27:58 GMT https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3477#M791590 krishna20 2018-01-19T09:27:58Z Re: Weekstart day result is not getting as expected https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3478#M791591 <HTML><HEAD></HEAD><BODY><P>Try this may be</P><P></P><P><STRONG>Num(Month(<SPAN style="color: #ff0000;">WeekStart(Master_Date, 0)</SPAN>))&amp; '-' &amp; Day(WeekStart(Master_Date, 0))&nbsp; as ACDWeekMonth</STRONG></P></BODY></HTML> Fri, 19 Jan 2018 09:32:58 GMT https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3478#M791591 sunny_talwar 2018-01-19T09:32:58Z Re: Weekstart day result is not getting as expected https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3479#M791592 <HTML><HEAD></HEAD><BODY><P>Thank you very Much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> That's worked perfectly.</P></BODY></HTML> Fri, 19 Jan 2018 10:39:22 GMT https://community.qlik.com/t5/QlikView/Weekstart-day-result-is-not-getting-as-expected/m-p/3479#M791592 krishna20 2018-01-19T10:39:22Z