topic date range - setdateyear in QlikView https://community.qlik.com/t5/QlikView/date-range-setdateyear/m-p/179475#M46306 <HTML><HEAD></HEAD><BODY><P>analyzing a set of data between 2 dates</P><P>achieved for the current year:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">Count (if ((Created-ReportFromDate)&gt;=0 AND (ReportToDate-Created&gt;=0), Description))</PRE><BR /><BR /> <P>but when I try to apply the same logic for the previous year by using the setdateyear function, it does not work anymore</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">Count (if (((SetDateYear([Created],2010)-SetDateYear(ReportFromDate,2010))&gt;=0 AND (SetDateYear(ReportToDate,2010)-SetDateYear([Created],2010))&gt;=0), Description))</PRE><BR /><BR /> <P>Any idea?</P><P>QV PE 10</P></BODY></HTML> Fri, 21 Jan 2011 17:39:33 GMT 2011-01-21T17:39:33Z date range - setdateyear https://community.qlik.com/t5/QlikView/date-range-setdateyear/m-p/179475#M46306 <HTML><HEAD></HEAD><BODY><P>analyzing a set of data between 2 dates</P><P>achieved for the current year:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">Count (if ((Created-ReportFromDate)&gt;=0 AND (ReportToDate-Created&gt;=0), Description))</PRE><BR /><BR /> <P>but when I try to apply the same logic for the previous year by using the setdateyear function, it does not work anymore</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">Count (if (((SetDateYear([Created],2010)-SetDateYear(ReportFromDate,2010))&gt;=0 AND (SetDateYear(ReportToDate,2010)-SetDateYear([Created],2010))&gt;=0), Description))</PRE><BR /><BR /> <P>Any idea?</P><P>QV PE 10</P></BODY></HTML> Fri, 21 Jan 2011 17:39:33 GMT https://community.qlik.com/t5/QlikView/date-range-setdateyear/m-p/179475#M46306 2011-01-21T17:39:33Z