topic Re: YTD with excluding specific days in QlikView https://community.qlik.com/t5/QlikView/YTD-with-excluding-specific-days/m-p/1040806#M940933 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">May be this:</SPAN></P><P></P><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>Sum({&lt;Year=, Month=, Quarter=, Week=, DateField=, DateNum={"&gt;=$(=Num(YearStart(Max(DateNum))<SPAN style="color: #ff0000;"> + 2</SPAN>))&lt;=$(=Max(DateNum))"}&gt;} Sales)</STRONG></SPAN></P></BODY></HTML> Wed, 03 Feb 2016 14:43:40 GMT sunny_talwar 2016-02-03T14:43:40Z YTD with excluding specific days https://community.qlik.com/t5/QlikView/YTD-with-excluding-specific-days/m-p/1040805#M940932 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have calculated YTD by using below link</P><P></P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum({&lt;Year=, Month=, Quarter=, Week=, DateField=, DateNum={"&gt;=$(=Num(YearStart(Max(DateNum))))&lt;=$(=Max(DateNum))"}&gt;} Sales)</SPAN></P><P></P><P><A href="https://community.qlik.com/docs/DOC-6163">YTQ, QTD, MTD and WTD</A></P><P></P><P></P><P>But i need to exclude January 1st and 2nd from the calculation.</P><P></P><P>Is it possible.</P><P></P><P>Thank You</P></BODY></HTML> Wed, 03 Feb 2016 14:41:48 GMT https://community.qlik.com/t5/QlikView/YTD-with-excluding-specific-days/m-p/1040805#M940932 anuradhaa 2016-02-03T14:41:48Z Re: YTD with excluding specific days https://community.qlik.com/t5/QlikView/YTD-with-excluding-specific-days/m-p/1040806#M940933 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;">May be this:</SPAN></P><P></P><P><SPAN style="color: #575757; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>Sum({&lt;Year=, Month=, Quarter=, Week=, DateField=, DateNum={"&gt;=$(=Num(YearStart(Max(DateNum))<SPAN style="color: #ff0000;"> + 2</SPAN>))&lt;=$(=Max(DateNum))"}&gt;} Sales)</STRONG></SPAN></P></BODY></HTML> Wed, 03 Feb 2016 14:43:40 GMT https://community.qlik.com/t5/QlikView/YTD-with-excluding-specific-days/m-p/1040806#M940933 sunny_talwar 2016-02-03T14:43:40Z Re: YTD with excluding specific days https://community.qlik.com/t5/QlikView/YTD-with-excluding-specific-days/m-p/1040807#M940934 <HTML><HEAD></HEAD><BODY><P>Are you need YTD from weekStart ? Update the YTD flag in the script to compensate tthe weekstart instead of Jan 1st.</P></BODY></HTML> Wed, 03 Feb 2016 14:46:09 GMT https://community.qlik.com/t5/QlikView/YTD-with-excluding-specific-days/m-p/1040807#M940934 2016-02-03T14:46:09Z