topic Re: Calculating PYTD YTD profits in QlikView https://community.qlik.com/t5/QlikView/Calculating-PYTD-YTD-profits/m-p/2078272#M1223937 <P>Hi</P> <P>Try like below,</P> <P>Hope you have Year field</P> <P>YTD =Sum({&lt;Year={$(=Max(Year))}&gt;}VALUE)</P> <P>PYTD <SPAN>=Sum({&lt;Year={$(=Max(Year)-1)}, Date={"&lt;=$(=AddYears(Max(Date),-1))"}&gt;}VALUE)</SPAN></P> Wed, 31 May 2023 09:47:01 GMT MayilVahanan 2023-05-31T09:47:01Z Calculating PYTD YTD profits https://community.qlik.com/t5/QlikView/Calculating-PYTD-YTD-profits/m-p/2078267#M1223936 <P>Hello,</P> <P>I am new to qlikview and i want to calculate the clean profits from the previous year to day versus year to day having the below data and their differences.</P> <TABLE width="553"> <TBODY> <TR> <TD width="127"> <P>DATE</P> </TD> <TD width="100"> <P>VALUE</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127"> <P>DATE</P> </TD> <TD width="100"> <P>VALUE</P> </TD> </TR> <TR> <TD width="127"> <P>31/01/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 100,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127"> <P>31/01/2023</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 150,00 €</P> </TD> </TR> <TR> <TD width="127"> <P>28/02/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 101,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127"> <P>28/02/2023</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 150,00 €</P> </TD> </TR> <TR> <TD width="127"> <P>31/03/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 102,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127"> <P>31/03/2023</P> </TD> <TD width="100"> <P>&nbsp;&nbsp;&nbsp;&nbsp; 90,00 €</P> </TD> </TR> <TR> <TD width="127"> <P>30/04/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 103,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127"> <P>30/04/2023</P> </TD> <TD width="100"> <P>&nbsp;&nbsp;&nbsp;&nbsp; 80,00 €</P> </TD> </TR> <TR> <TD width="127"> <P>31/05/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 104,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127"> <P>31/05/2023</P> </TD> <TD width="100"> <P>&nbsp;&nbsp;&nbsp;&nbsp; 20,00 €</P> </TD> </TR> <TR> <TD width="127"> <P>30/06/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 105,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127">&nbsp;</TD> <TD width="100">&nbsp;</TD> </TR> <TR> <TD width="127"> <P>30/07/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 105,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127">&nbsp;</TD> <TD width="100">&nbsp;</TD> </TR> <TR> <TD width="127"> <P>31/08/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 107,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127">&nbsp;</TD> <TD width="100">&nbsp;</TD> </TR> <TR> <TD width="127"> <P>30/09/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 108,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127">&nbsp;</TD> <TD width="100">&nbsp;</TD> </TR> <TR> <TD width="127"> <P>31/10/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 109,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127">&nbsp;</TD> <TD width="100">&nbsp;</TD> </TR> <TR> <TD width="127"> <P>30/11/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 110,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127">&nbsp;</TD> <TD width="100">&nbsp;</TD> </TR> <TR> <TD width="127"> <P>31/12/2022</P> </TD> <TD width="100"> <P>&nbsp;&nbsp; 111,00 €</P> </TD> <TD width="100">&nbsp;</TD> <TD width="127">&nbsp;</TD> <TD width="100">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <TABLE width="303"> <TBODY> <TR> <TD colspan="2" width="205"> <P>&nbsp;RESULT</P> </TD> <TD width="98">&nbsp;</TD> </TR> <TR> <TD width="102"> <P>pytd</P> </TD> <TD width="102"> <P>ytd</P> </TD> <TD width="98"> <P>Diff%</P> </TD> </TR> <TR> <TD width="102"> <P>&nbsp;&nbsp; 510,00 €</P> </TD> <TD width="102"> <P>&nbsp;&nbsp; 490,00 €</P> </TD> <TD width="98">&nbsp;</TD> </TR> </TBODY> </TABLE> Wed, 31 May 2023 09:34:51 GMT https://community.qlik.com/t5/QlikView/Calculating-PYTD-YTD-profits/m-p/2078267#M1223936 oze 2023-05-31T09:34:51Z Re: Calculating PYTD YTD profits https://community.qlik.com/t5/QlikView/Calculating-PYTD-YTD-profits/m-p/2078272#M1223937 <P>Hi</P> <P>Try like below,</P> <P>Hope you have Year field</P> <P>YTD =Sum({&lt;Year={$(=Max(Year))}&gt;}VALUE)</P> <P>PYTD <SPAN>=Sum({&lt;Year={$(=Max(Year)-1)}, Date={"&lt;=$(=AddYears(Max(Date),-1))"}&gt;}VALUE)</SPAN></P> Wed, 31 May 2023 09:47:01 GMT https://community.qlik.com/t5/QlikView/Calculating-PYTD-YTD-profits/m-p/2078272#M1223937 MayilVahanan 2023-05-31T09:47:01Z