https://community.qlik.com/t5/App-Development/Sales-current-year-vs-Sales-previous-year-by-date/m-p/2473236#M99865 <P>You can do a pivot calendar, it simplify the set analysis :</P> <P><A href="https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130" target="_blank">https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130</A></P> <P>Regards</P> Fri, 26 Jul 2024 13:30:34 GMT paulcalvet 2024-07-26T13:30:34Z https://community.qlik.com/t5/App-Development/Sales-current-year-vs-Sales-previous-year-by-date/m-p/2473207#M99855 <P>Hello,</P> <P>I have the following straight table in QlikSense</P> <P>and i have choose from the filter the Year 2024 and the month 06</P> <P>the first column is the dimension : Date,</P> <P>the second column is the expression : sum(Sales)</P> <P>the third column is calculated dimension : date(Date - 364,'DD/MM/YYYY')</P> <P>the question is how can i calculate the fourth column with the Sales of the Date Previous Year ?</P> <P>Can anyone help me with this issue ?</P> <TABLE width="373"> <TBODY> <TR> <TD width="89">Date Current Year</TD> <TD width="92">Sales Current Year</TD> <TD width="94">Date Previous Year</TD> <TD width="98">Sales Previous Year</TD> </TR> <TR> <TD>01/06/2024</TD> <TD>211.074</TD> <TD>03/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>02/06/2024</TD> <TD>190.737</TD> <TD>04/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>03/06/2024</TD> <TD>410.141</TD> <TD>05/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>04/06/2024</TD> <TD>413.592</TD> <TD>06/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>05/06/2024</TD> <TD>377.148</TD> <TD>07/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>06/06/2024</TD> <TD>402.440</TD> <TD>08/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>07/06/2024</TD> <TD>405.284</TD> <TD>09/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>08/06/2024</TD> <TD>204.376</TD> <TD>10/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>09/06/2024</TD> <TD>190.280</TD> <TD>11/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>10/06/2024</TD> <TD>387.923</TD> <TD>12/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>11/06/2024</TD> <TD>394.654</TD> <TD>13/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>12/06/2024</TD> <TD>372.037</TD> <TD>14/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>13/06/2024</TD> <TD>399.318</TD> <TD>15/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>14/06/2024</TD> <TD>377.616</TD> <TD>16/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>15/06/2024</TD> <TD>205.255</TD> <TD>17/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>16/06/2024</TD> <TD>189.938</TD> <TD>18/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>17/06/2024</TD> <TD>384.092</TD> <TD>19/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>18/06/2024</TD> <TD>385.022</TD> <TD>20/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>19/06/2024</TD> <TD>371.111</TD> <TD>21/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>20/06/2024</TD> <TD>399.060</TD> <TD>22/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>21/06/2024</TD> <TD>393.112</TD> <TD>23/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>22/06/2024</TD> <TD>174.278</TD> <TD>24/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>23/06/2024</TD> <TD>184.376</TD> <TD>25/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>24/06/2024</TD> <TD>373.214</TD> <TD>26/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>25/06/2024</TD> <TD>352.740</TD> <TD>27/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>26/06/2024</TD> <TD>346.913</TD> <TD>28/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>27/06/2024</TD> <TD>392.745</TD> <TD>29/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>28/06/2024</TD> <TD>405.292</TD> <TD>30/06/2023</TD> <TD>-</TD> </TR> <TR> <TD>29/06/2024</TD> <TD>198.773</TD> <TD>01/07/2023</TD> <TD>-</TD> </TR> <TR> <TD>30/06/2024</TD> <TD>226.077</TD> <TD>02/07/2023</TD> <TD>-</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you in advanced.</P> <P>&nbsp;</P> Fri, 26 Jul 2024 11:17:57 GMT https://community.qlik.com/t5/App-Development/Sales-current-year-vs-Sales-previous-year-by-date/m-p/2473207#M99855 geogou1973 2024-07-26T11:17:57Z https://community.qlik.com/t5/App-Development/Sales-current-year-vs-Sales-previous-year-by-date/m-p/2473210#M99856 <P>For the same period in the previous year, use the following:</P> <P>=Sum({$&lt;Date={"&gt;=$(=YearStart(Max(Date), -1))&lt;=$(=AddYears(Max(Date), -1))"},Year,Quarter,Month,Week&gt;}Sales)</P> Fri, 26 Jul 2024 11:30:04 GMT https://community.qlik.com/t5/App-Development/Sales-current-year-vs-Sales-previous-year-by-date/m-p/2473210#M99856 BrunPierre 2024-07-26T11:30:04Z https://community.qlik.com/t5/App-Development/Sales-current-year-vs-Sales-previous-year-by-date/m-p/2473236#M99865 <P>You can do a pivot calendar, it simplify the set analysis :</P> <P><A href="https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130" target="_blank">https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130</A></P> <P>Regards</P> Fri, 26 Jul 2024 13:30:34 GMT https://community.qlik.com/t5/App-Development/Sales-current-year-vs-Sales-previous-year-by-date/m-p/2473236#M99865 paulcalvet 2024-07-26T13:30:34Z