https://community.qlik.com/t5/QlikView/Annual-Leave-used-last-12-months/m-p/1948286#M1219645 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/17306">@ashmitp869</a>&nbsp; Try using below Expression.</P> <P>Count({&lt;Date={"&gt;=$(=MonthStart(Today(), -11))&lt;=$(=Today())"}&gt;}Total_Leave_Days)</P> Mon, 27 Jun 2022 06:23:39 GMT sidhiq91 2022-06-27T06:23:39Z https://community.qlik.com/t5/QlikView/Annual-Leave-used-last-12-months/m-p/1948270#M1219641 <P>Hi ,</P> <P>How can I calculate <SPAN>Annual Leave used (last 12 months) from the column "TOTAL_LEAVE_DAYS"</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ashmitp869_0-1656305169364.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/82679i1AB561AE8B2E6AD8/image-size/medium?v=v2&amp;px=400" role="button" title="ashmitp869_0-1656305169364.png" alt="ashmitp869_0-1656305169364.png" /></span></P> <P>&nbsp;</P> Mon, 27 Jun 2022 04:47:16 GMT https://community.qlik.com/t5/QlikView/Annual-Leave-used-last-12-months/m-p/1948270#M1219641 ashmitp869 2022-06-27T04:47:16Z https://community.qlik.com/t5/QlikView/Annual-Leave-used-last-12-months/m-p/1948286#M1219645 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/17306">@ashmitp869</a>&nbsp; Try using below Expression.</P> <P>Count({&lt;Date={"&gt;=$(=MonthStart(Today(), -11))&lt;=$(=Today())"}&gt;}Total_Leave_Days)</P> Mon, 27 Jun 2022 06:23:39 GMT https://community.qlik.com/t5/QlikView/Annual-Leave-used-last-12-months/m-p/1948286#M1219645 sidhiq91 2022-06-27T06:23:39Z