topic YTD calculation - need help with Set Analysis in QlikView https://community.qlik.com/t5/QlikView/YTD-calculation-need-help-with-Set-Analysis/m-p/753125#M471808 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am trying to calculate YTD using <SPAN style="font-size: 13.3333330154419px;">DayNumberOfYear()</SPAN>. My calendar is FY, first month is Oct. In MasterCalendar I have added <EM>DayNumberOfYear(DateofSale,10) as <SPAN style="color: #ff0000;">DayNbrOfYear</SPAN></EM> now in the set analysis I am trying to check a range if day falls between day 1 and the day number as of Today(). Problem is it is not giving me syntax error and not calculating it properly. For e.g as of today it should add up only day 1-142 it is adding up entire Year.</P><P>sum({$&lt;DayNbrOfYear={"<SPAN style="color: #ff0000;"><STRONG>&gt;=1&lt;=({</STRONG></SPAN><SPAN style="color: #ff0000;"><STRONG>DayNumberOfYear(today(),10)</STRONG></SPAN>})"}&gt;} Qty)</P><P></P><P>Please help. I am new to QV and have not much experience with Set Analysis.</P><P>Thanks</P><P>Rashid</P></BODY></HTML> Thu, 19 Feb 2015 16:11:52 GMT rmuhammad 2015-02-19T16:11:52Z YTD calculation - need help with Set Analysis https://community.qlik.com/t5/QlikView/YTD-calculation-need-help-with-Set-Analysis/m-p/753125#M471808 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am trying to calculate YTD using <SPAN style="font-size: 13.3333330154419px;">DayNumberOfYear()</SPAN>. My calendar is FY, first month is Oct. In MasterCalendar I have added <EM>DayNumberOfYear(DateofSale,10) as <SPAN style="color: #ff0000;">DayNbrOfYear</SPAN></EM> now in the set analysis I am trying to check a range if day falls between day 1 and the day number as of Today(). Problem is it is not giving me syntax error and not calculating it properly. For e.g as of today it should add up only day 1-142 it is adding up entire Year.</P><P>sum({$&lt;DayNbrOfYear={"<SPAN style="color: #ff0000;"><STRONG>&gt;=1&lt;=({</STRONG></SPAN><SPAN style="color: #ff0000;"><STRONG>DayNumberOfYear(today(),10)</STRONG></SPAN>})"}&gt;} Qty)</P><P></P><P>Please help. I am new to QV and have not much experience with Set Analysis.</P><P>Thanks</P><P>Rashid</P></BODY></HTML> Thu, 19 Feb 2015 16:11:52 GMT https://community.qlik.com/t5/QlikView/YTD-calculation-need-help-with-Set-Analysis/m-p/753125#M471808 rmuhammad 2015-02-19T16:11:52Z Re: YTD calculation - need help with Set Analysis https://community.qlik.com/t5/QlikView/YTD-calculation-need-help-with-Set-Analysis/m-p/753126#M471809 <HTML><HEAD></HEAD><BODY><P>Try </P><P>sum({$&lt;DayNbrOfYear={"&lt;=$(=DayNumberOfYear(today(),10))"}&gt;} Qty)</P><P></P><P>HIC</P></BODY></HTML> Thu, 19 Feb 2015 16:26:16 GMT https://community.qlik.com/t5/QlikView/YTD-calculation-need-help-with-Set-Analysis/m-p/753126#M471809 hic 2015-02-19T16:26:16Z Re: YTD calculation - need help with Set Analysis https://community.qlik.com/t5/QlikView/YTD-calculation-need-help-with-Set-Analysis/m-p/753127#M471810 <HTML><HEAD></HEAD><BODY><P>Thanks Henric! You are the Best <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 19 Feb 2015 16:30:23 GMT https://community.qlik.com/t5/QlikView/YTD-calculation-need-help-with-Set-Analysis/m-p/753127#M471810 rmuhammad 2015-02-19T16:30:23Z