topic LYTD in QlikView https://community.qlik.com/t5/QlikView/LYTD/m-p/94024#M766186 <HTML><HEAD></HEAD><BODY><P>=Sum({&lt;INSTALL_DATE={"&gt;=$(=Date(YearStart(Max(today()),-1)))&lt;=$(=Date(addyears(Max(today()),-1))) "}&gt;}[2017Liquidations])</P><P></P><P>Hello. My LYTD function is returning the whole year sum. How can I fix this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z LYTD https://community.qlik.com/t5/QlikView/LYTD/m-p/94024#M766186 <HTML><HEAD></HEAD><BODY><P>=Sum({&lt;INSTALL_DATE={"&gt;=$(=Date(YearStart(Max(today()),-1)))&lt;=$(=Date(addyears(Max(today()),-1))) "}&gt;}[2017Liquidations])</P><P></P><P>Hello. My LYTD function is returning the whole year sum. How can I fix this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/LYTD/m-p/94024#M766186 Anonymous 2020-11-25T16:16:04Z Re: LYTD https://community.qlik.com/t5/QlikView/LYTD/m-p/94025#M766187 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P><STRONG>=Sum({&lt;INSTALL_DATE = {"&gt;=$(=Date(YearStart(Today(), -1)))&lt;=$(=Date(AddYears(Today(), -1)))"}&gt;} [2017Liquidations])</STRONG></P></BODY></HTML> Fri, 29 Jun 2018 03:08:08 GMT https://community.qlik.com/t5/QlikView/LYTD/m-p/94025#M766187 sunny_talwar 2018-06-29T03:08:08Z