https://community.qlik.com/t5/QlikView/How-many-rows-I-have-between-two-dates/m-p/1701210#M726180 <P>Try this:</P><P><FONT face="courier new,courier"><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/count.htm" target="_self">count</A>({&lt;Date = {"&gt;=$(=<A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/addyears.htm" target="_self">addyears</A>(today(),-1))&lt;$(=today())"}&gt;} <SPAN>Fechamento</SPAN>)</FONT></P> Tue, 12 May 2020 16:19:15 GMT Vegar 2020-05-12T16:19:15Z https://community.qlik.com/t5/QlikView/How-many-rows-I-have-between-two-dates/m-p/1701202#M726179 <P>Dears,</P><P>How can I get the number of rows I have of the field (Fechamento), between Today() and Today - 1 Year?</P><P>&nbsp;</P><TABLE width="139"><TBODY><TR><TD width="75">Date</TD><TD width="64">Fechamento</TD></TR><TR><TD>12/05/2020</TD><TD>2</TD></TR><TR><TD>12/04/2020</TD><TD>3</TD></TR><TR><TD>12/02/2020</TD><TD>4</TD></TR><TR><TD>13/01/2020</TD><TD>5</TD></TR><TR><TD>14/11/2019</TD><TD>7</TD></TR><TR><TD>15/10/2019</TD><TD>6</TD></TR><TR><TD>15/09/2019</TD><TD>6</TD></TR><TR><TD>17/07/2019</TD><TD>8</TD></TR><TR><TD>17/06/2019</TD><TD>9</TD></TR><TR><TD>18/05/2019</TD><TD>2</TD></TR><TR><TD>18/04/2019</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>IN this example, I'm expecting 10 as result!</P><P>In other words, how can I get the number, of values between two dates? How can I count the quantity, not the total, of values between today and one year ago?</P><P>&nbsp;</P><P>Thanks&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-many-rows-I-have-between-two-dates/m-p/1701202#M726179 brunolelli87 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/How-many-rows-I-have-between-two-dates/m-p/1701210#M726180 <P>Try this:</P><P><FONT face="courier new,courier"><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/CounterAggregationFunctions/count.htm" target="_self">count</A>({&lt;Date = {"&gt;=$(=<A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/addyears.htm" target="_self">addyears</A>(today(),-1))&lt;$(=today())"}&gt;} <SPAN>Fechamento</SPAN>)</FONT></P> Tue, 12 May 2020 16:19:15 GMT https://community.qlik.com/t5/QlikView/How-many-rows-I-have-between-two-dates/m-p/1701210#M726180 Vegar 2020-05-12T16:19:15Z https://community.qlik.com/t5/QlikView/How-many-rows-I-have-between-two-dates/m-p/1701215#M726181 <P>Perfect Vegar!</P><P>You are the best...</P> Tue, 12 May 2020 16:57:27 GMT https://community.qlik.com/t5/QlikView/How-many-rows-I-have-between-two-dates/m-p/1701215#M726181 brunolelli87 2020-05-12T16:57:27Z