topic Current vs Previous calculation by Date in App Development https://community.qlik.com/t5/App-Development/Current-vs-Previous-calculation-by-Date/m-p/2026504#M84624 <P>Hello,</P> <P>i want to simulate the following table in QlikSense</P> <TABLE width="440"> <TBODY> <TR> <TD width="110">2022</TD> <TD width="110">AMT 2022</TD> <TD width="110">2021</TD> <TD width="110">AMT 2021</TD> </TR> <TR> <TD>01/11/2022</TD> <TD>59.047</TD> <TD>02/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>02/11/2022</TD> <TD>68.525</TD> <TD>03/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>03/11/2022</TD> <TD>64.932</TD> <TD>04/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>04/11/2022</TD> <TD>64.515</TD> <TD>05/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>05/11/2022</TD> <TD>54.750</TD> <TD>06/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>07/11/2022</TD> <TD>70.280</TD> <TD>08/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>08/11/2022</TD> <TD>64.952</TD> <TD>09/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>09/11/2022</TD> <TD>57.875</TD> <TD>10/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>10/11/2022</TD> <TD>51.512</TD> <TD>11/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>11/11/2022</TD> <TD>54.736</TD> <TD>12/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>12/11/2022</TD> <TD>42.609</TD> <TD>13/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>13/11/2022</TD> <TD>3.726</TD> <TD>14/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>14/11/2022</TD> <TD>59.381</TD> <TD>15/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>15/11/2022</TD> <TD>54.818</TD> <TD>16/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>16/11/2022</TD> <TD>53.809</TD> <TD>17/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>17/11/2022</TD> <TD>50.098</TD> <TD>18/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>18/11/2022</TD> <TD>43.913</TD> <TD>19/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>19/11/2022</TD> <TD>54.818</TD> <TD>20/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>20/11/2022</TD> <TD>5.724</TD> <TD>21/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>21/11/2022</TD> <TD>57.042</TD> <TD>22/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>22/11/2022</TD> <TD>55.196</TD> <TD>23/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>23/11/2022</TD> <TD>51.080</TD> <TD>24/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>24/11/2022</TD> <TD>54.214</TD> <TD>25/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>25/11/2022</TD> <TD>49.940</TD> <TD>26/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>26/11/2022</TD> <TD>38.207</TD> <TD>27/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>27/11/2022</TD> <TD>8.348</TD> <TD>28/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>28/11/2022</TD> <TD>59.549</TD> <TD>29/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>29/11/2022</TD> <TD>62.654</TD> <TD>30/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>30/11/2022</TD> <TD>55.348</TD> <TD>01/12/2021</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The first column i have the calculated dimension&nbsp;=if([YEAR] = $(=max([YEAR])), [DATE])</P> <P>The second column i have the measure&nbsp;sum({&lt;[YEAR]={ $(=max([YEAR]))}&gt;} SALES)</P> <P>The third column i have the&nbsp;calculated dimension&nbsp;=if([YEAR] = $(=max([YEAR])), date(DATE]-364,'DD/MM/YYYY'))</P> <P>My question is with which measure can i calculate the fourth column with the SALES of the third dimension ?</P> <P>Has anyone an idea to help me ?</P> <P>Thank you in advance.</P> Tue, 17 Jan 2023 09:38:16 GMT geogou1973 2023-01-17T09:38:16Z Current vs Previous calculation by Date https://community.qlik.com/t5/App-Development/Current-vs-Previous-calculation-by-Date/m-p/2026504#M84624 <P>Hello,</P> <P>i want to simulate the following table in QlikSense</P> <TABLE width="440"> <TBODY> <TR> <TD width="110">2022</TD> <TD width="110">AMT 2022</TD> <TD width="110">2021</TD> <TD width="110">AMT 2021</TD> </TR> <TR> <TD>01/11/2022</TD> <TD>59.047</TD> <TD>02/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>02/11/2022</TD> <TD>68.525</TD> <TD>03/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>03/11/2022</TD> <TD>64.932</TD> <TD>04/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>04/11/2022</TD> <TD>64.515</TD> <TD>05/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>05/11/2022</TD> <TD>54.750</TD> <TD>06/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>07/11/2022</TD> <TD>70.280</TD> <TD>08/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>08/11/2022</TD> <TD>64.952</TD> <TD>09/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>09/11/2022</TD> <TD>57.875</TD> <TD>10/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>10/11/2022</TD> <TD>51.512</TD> <TD>11/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>11/11/2022</TD> <TD>54.736</TD> <TD>12/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>12/11/2022</TD> <TD>42.609</TD> <TD>13/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>13/11/2022</TD> <TD>3.726</TD> <TD>14/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>14/11/2022</TD> <TD>59.381</TD> <TD>15/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>15/11/2022</TD> <TD>54.818</TD> <TD>16/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>16/11/2022</TD> <TD>53.809</TD> <TD>17/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>17/11/2022</TD> <TD>50.098</TD> <TD>18/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>18/11/2022</TD> <TD>43.913</TD> <TD>19/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>19/11/2022</TD> <TD>54.818</TD> <TD>20/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>20/11/2022</TD> <TD>5.724</TD> <TD>21/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>21/11/2022</TD> <TD>57.042</TD> <TD>22/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>22/11/2022</TD> <TD>55.196</TD> <TD>23/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>23/11/2022</TD> <TD>51.080</TD> <TD>24/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>24/11/2022</TD> <TD>54.214</TD> <TD>25/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>25/11/2022</TD> <TD>49.940</TD> <TD>26/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>26/11/2022</TD> <TD>38.207</TD> <TD>27/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>27/11/2022</TD> <TD>8.348</TD> <TD>28/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>28/11/2022</TD> <TD>59.549</TD> <TD>29/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>29/11/2022</TD> <TD>62.654</TD> <TD>30/11/2021</TD> <TD>0</TD> </TR> <TR> <TD>30/11/2022</TD> <TD>55.348</TD> <TD>01/12/2021</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The first column i have the calculated dimension&nbsp;=if([YEAR] = $(=max([YEAR])), [DATE])</P> <P>The second column i have the measure&nbsp;sum({&lt;[YEAR]={ $(=max([YEAR]))}&gt;} SALES)</P> <P>The third column i have the&nbsp;calculated dimension&nbsp;=if([YEAR] = $(=max([YEAR])), date(DATE]-364,'DD/MM/YYYY'))</P> <P>My question is with which measure can i calculate the fourth column with the SALES of the third dimension ?</P> <P>Has anyone an idea to help me ?</P> <P>Thank you in advance.</P> Tue, 17 Jan 2023 09:38:16 GMT https://community.qlik.com/t5/App-Development/Current-vs-Previous-calculation-by-Date/m-p/2026504#M84624 geogou1973 2023-01-17T09:38:16Z Re: Current vs Previous calculation by Date https://community.qlik.com/t5/App-Development/Current-vs-Previous-calculation-by-Date/m-p/2028573#M84754 <P>Hi!</P> <P>First of all, you can not have in the same table 1 column with todays dates, and values of toadies days, and other column with last year dates and values of last dates because Qlik is evaluating each row (unless you go through unneeded complex logic).</P> <P>The measure you are looking for is:</P> <P>Sum({&lt;[Year]={$(=max([Year])-1)}, DateNum={"&gt;=$(=Max(DateNum)-364)"}&gt;} 1)</P> <P>But, it will be 0 in all Max Year rows:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="zar_0-1674391926034.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/98571i84E6FD408562C3ED/image-size/medium?v=v2&amp;px=400" role="button" title="zar_0-1674391926034.png" alt="zar_0-1674391926034.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 22 Jan 2023 12:55:28 GMT https://community.qlik.com/t5/App-Development/Current-vs-Previous-calculation-by-Date/m-p/2028573#M84754 zar 2023-01-22T12:55:28Z