topic Comparison Last Year Sales Based On The Given Date Selection in App Development https://community.qlik.com/t5/App-Development/Comparison-Last-Year-Sales-Based-On-The-Given-Date-Selection/m-p/2052874#M86527 <P>Hi All,</P> <P>I have created the Current Year and Last Year sales reports separately. I need to show the last year sales based on the given date.</P> <TABLE width="215"> <TBODY> <TR> <TD width="76">Working Day</TD> <TD width="70">CY DateKey</TD> <TD width="69">LY DateKey</TD> </TR> <TR> <TD>1</TD> <TD>20230301</TD> <TD>20220301</TD> </TR> <TR> <TD>2</TD> <TD>20230302</TD> <TD>20220302</TD> </TR> <TR> <TD>3</TD> <TD>20230303</TD> <TD>20220303</TD> </TR> <TR> <TD>4</TD> <TD>20230304</TD> <TD>20220304</TD> </TR> <TR> <TD>5</TD> <TD>20230305</TD> <TD>20220304</TD> </TR> <TR> <TD>6</TD> <TD>20230306</TD> <TD>20220305</TD> </TR> <TR> <TD>7</TD> <TD>20230307</TD> <TD>20220307</TD> </TR> <TR> <TD>8</TD> <TD>20230308</TD> <TD>20220308</TD> </TR> <TR> <TD>9</TD> <TD>20230309</TD> <TD>20220309</TD> </TR> <TR> <TD>10</TD> <TD>20230310</TD> <TD>20220310</TD> </TR> <TR> <TD>11</TD> <TD>20230311</TD> <TD>20220310</TD> </TR> <TR> <TD>12</TD> <TD>20230312</TD> <TD>20220311</TD> </TR> <TR> <TD>13</TD> <TD>20230313</TD> <TD>20220311</TD> </TR> <TR> <TD>14</TD> <TD>20230314</TD> <TD>20220312</TD> </TR> <TR> <TD>15</TD> <TD>20230315</TD> <TD>20220314</TD> </TR> <TR> <TD>16</TD> <TD>20230316</TD> <TD>20220315</TD> </TR> <TR> <TD>17</TD> <TD>20230317</TD> <TD>20220316</TD> </TR> <TR> <TD>18</TD> <TD>20230318</TD> <TD>20220317</TD> </TR> <TR> <TD>19</TD> <TD>20230319</TD> <TD>20220318</TD> </TR> <TR> <TD>20</TD> <TD>20230320</TD> <TD>20220318</TD> </TR> <TR> <TD>21</TD> <TD>20230321</TD> <TD>20220319</TD> </TR> <TR> <TD>22</TD> <TD>20230322</TD> <TD>20220321</TD> </TR> <TR> <TD>23</TD> <TD>20230323</TD> <TD>20220323</TD> </TR> <TR> <TD>24</TD> <TD>20230324</TD> <TD>20220324</TD> </TR> <TR> <TD>25</TD> <TD>20230325</TD> <TD>20220325</TD> </TR> <TR> <TD>26</TD> <TD>20230326</TD> <TD>20220325</TD> </TR> <TR> <TD>27</TD> <TD>20230327</TD> <TD>20220326</TD> </TR> <TR> <TD>28</TD> <TD>20230328</TD> <TD>20220328</TD> </TR> <TR> <TD>29</TD> <TD>20230329</TD> <TD>20220329</TD> </TR> <TR> <TD>30</TD> <TD>20230330</TD> <TD>20220330</TD> </TR> <TR> <TD>31</TD> <TD>20230331</TD> <TD>20220331</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I select DateKey as 20230313 but LY sales should be show till 20220311 date. Same as remaining above dates.</P> <P>Sum({&lt;Year = {$(=max(Year)-1)},Date_Key = {"&lt;=$(=Date(AddYears(Date#(Max(Date_Key),'YYYYMMDD'), -1), 'YYYYMMDD'))"}&gt;}Sales_Value)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dineshm030_0-1679653420373.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103436iD0A05CBAB97C5F2B/image-size/medium?v=v2&amp;px=400" role="button" title="dineshm030_0-1679653420373.png" alt="dineshm030_0-1679653420373.png" /></span></P> <P>Thanks in advance.</P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/17935">@MayilVahanan</a>&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P> Fri, 24 Mar 2023 10:27:30 GMT dineshm030 2023-03-24T10:27:30Z Comparison Last Year Sales Based On The Given Date Selection https://community.qlik.com/t5/App-Development/Comparison-Last-Year-Sales-Based-On-The-Given-Date-Selection/m-p/2052874#M86527 <P>Hi All,</P> <P>I have created the Current Year and Last Year sales reports separately. I need to show the last year sales based on the given date.</P> <TABLE width="215"> <TBODY> <TR> <TD width="76">Working Day</TD> <TD width="70">CY DateKey</TD> <TD width="69">LY DateKey</TD> </TR> <TR> <TD>1</TD> <TD>20230301</TD> <TD>20220301</TD> </TR> <TR> <TD>2</TD> <TD>20230302</TD> <TD>20220302</TD> </TR> <TR> <TD>3</TD> <TD>20230303</TD> <TD>20220303</TD> </TR> <TR> <TD>4</TD> <TD>20230304</TD> <TD>20220304</TD> </TR> <TR> <TD>5</TD> <TD>20230305</TD> <TD>20220304</TD> </TR> <TR> <TD>6</TD> <TD>20230306</TD> <TD>20220305</TD> </TR> <TR> <TD>7</TD> <TD>20230307</TD> <TD>20220307</TD> </TR> <TR> <TD>8</TD> <TD>20230308</TD> <TD>20220308</TD> </TR> <TR> <TD>9</TD> <TD>20230309</TD> <TD>20220309</TD> </TR> <TR> <TD>10</TD> <TD>20230310</TD> <TD>20220310</TD> </TR> <TR> <TD>11</TD> <TD>20230311</TD> <TD>20220310</TD> </TR> <TR> <TD>12</TD> <TD>20230312</TD> <TD>20220311</TD> </TR> <TR> <TD>13</TD> <TD>20230313</TD> <TD>20220311</TD> </TR> <TR> <TD>14</TD> <TD>20230314</TD> <TD>20220312</TD> </TR> <TR> <TD>15</TD> <TD>20230315</TD> <TD>20220314</TD> </TR> <TR> <TD>16</TD> <TD>20230316</TD> <TD>20220315</TD> </TR> <TR> <TD>17</TD> <TD>20230317</TD> <TD>20220316</TD> </TR> <TR> <TD>18</TD> <TD>20230318</TD> <TD>20220317</TD> </TR> <TR> <TD>19</TD> <TD>20230319</TD> <TD>20220318</TD> </TR> <TR> <TD>20</TD> <TD>20230320</TD> <TD>20220318</TD> </TR> <TR> <TD>21</TD> <TD>20230321</TD> <TD>20220319</TD> </TR> <TR> <TD>22</TD> <TD>20230322</TD> <TD>20220321</TD> </TR> <TR> <TD>23</TD> <TD>20230323</TD> <TD>20220323</TD> </TR> <TR> <TD>24</TD> <TD>20230324</TD> <TD>20220324</TD> </TR> <TR> <TD>25</TD> <TD>20230325</TD> <TD>20220325</TD> </TR> <TR> <TD>26</TD> <TD>20230326</TD> <TD>20220325</TD> </TR> <TR> <TD>27</TD> <TD>20230327</TD> <TD>20220326</TD> </TR> <TR> <TD>28</TD> <TD>20230328</TD> <TD>20220328</TD> </TR> <TR> <TD>29</TD> <TD>20230329</TD> <TD>20220329</TD> </TR> <TR> <TD>30</TD> <TD>20230330</TD> <TD>20220330</TD> </TR> <TR> <TD>31</TD> <TD>20230331</TD> <TD>20220331</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I select DateKey as 20230313 but LY sales should be show till 20220311 date. Same as remaining above dates.</P> <P>Sum({&lt;Year = {$(=max(Year)-1)},Date_Key = {"&lt;=$(=Date(AddYears(Date#(Max(Date_Key),'YYYYMMDD'), -1), 'YYYYMMDD'))"}&gt;}Sales_Value)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dineshm030_0-1679653420373.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103436iD0A05CBAB97C5F2B/image-size/medium?v=v2&amp;px=400" role="button" title="dineshm030_0-1679653420373.png" alt="dineshm030_0-1679653420373.png" /></span></P> <P>Thanks in advance.</P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/17935">@MayilVahanan</a>&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P> Fri, 24 Mar 2023 10:27:30 GMT https://community.qlik.com/t5/App-Development/Comparison-Last-Year-Sales-Based-On-The-Given-Date-Selection/m-p/2052874#M86527 dineshm030 2023-03-24T10:27:30Z