https://community.qlik.com/t5/QlikView/Value-changes-when-i-select-latest-month/m-p/1651770#M447904 <P>This is my expression which shows the correct number for last month if no selections are made , or if any selection is made it still works , except&nbsp; now when i select the latest month .</P><P>I noticed when i select the latest month the number changes slightly due to the KREF numbers not availble for the&nbsp; latest month , but dont understand why its affecting the previous months number which is the expression below&nbsp;</P><P>Sum( Aggr(Sum({&lt;SPERIOD={$(y_Speriod-1)},FIN_YR_NO=, MTH_SHORT_DESC=&gt;}DISTINCT no_rejection),Kref)</P> Sat, 16 Nov 2024 01:50:14 GMT vvvvvvizard 2024-11-16T01:50:14Z https://community.qlik.com/t5/QlikView/Value-changes-when-i-select-latest-month/m-p/1651770#M447904 <P>This is my expression which shows the correct number for last month if no selections are made , or if any selection is made it still works , except&nbsp; now when i select the latest month .</P><P>I noticed when i select the latest month the number changes slightly due to the KREF numbers not availble for the&nbsp; latest month , but dont understand why its affecting the previous months number which is the expression below&nbsp;</P><P>Sum( Aggr(Sum({&lt;SPERIOD={$(y_Speriod-1)},FIN_YR_NO=, MTH_SHORT_DESC=&gt;}DISTINCT no_rejection),Kref)</P> Sat, 16 Nov 2024 01:50:14 GMT https://community.qlik.com/t5/QlikView/Value-changes-when-i-select-latest-month/m-p/1651770#M447904 vvvvvvizard 2024-11-16T01:50:14Z https://community.qlik.com/t5/QlikView/Value-changes-when-i-select-latest-month/m-p/1656040#M448269 <P>Have a look at the following Design Blog post and see if that helps you resolve the why on this one, sorry I do not have something better for you:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822</A></P> <P>Regards,<BR />Brett</P> Tue, 10 Dec 2019 14:11:22 GMT https://community.qlik.com/t5/QlikView/Value-changes-when-i-select-latest-month/m-p/1656040#M448269 Brett_Bleess 2019-12-10T14:11:22Z