https://community.qlik.com/t5/QlikView/Selection-Issue/m-p/1925859#M1218767 <P><SPAN>RANGESUM(BELOW(SUM(DailyInterest),0,rowno())) + SUM(Interest)</SPAN></P> <P><SPAN>can you try above one</SPAN></P> Tue, 03 May 2022 19:47:21 GMT anat 2022-05-03T19:47:21Z https://community.qlik.com/t5/QlikView/Selection-Issue/m-p/1925705#M1218763 <P>Greetings to all,</P> <P>So I have this QVD where records seize to update incrementally, the last record is dated 25/04/2022. However, I enable to generate new dates to calculate the interest accrued with the expression; RANGESUM(BELOW(SUM(DailyInterest),0,NOOFROWS())) + SUM(Interest).&nbsp;</P> <P>My challenge is whenever&nbsp; I select any subsequent date, the amount defaults to 5,263.25, that's the initial amount as of 25/04/2022.</P> <P><STRONG>Table without any date selection</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peter_brown_0-1651584158934.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/78527i271941467BBF14EE/image-size/medium?v=v2&amp;px=400" role="button" title="peter_brown_0-1651584158934.png" alt="peter_brown_0-1651584158934.png" /></span></P> <P><STRONG>Table with 27/04/2022 selection</STRONG></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peter_brown_1-1651584320083.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/78528i8DDFF900B2F643FF/image-size/medium?v=v2&amp;px=400" role="button" title="peter_brown_1-1651584320083.png" alt="peter_brown_1-1651584320083.png" /></span></P> <P>Apparently, in the above scenario, the amount should read&nbsp;5,409.45 and not 5,263.25.</P> <P>Help me out here, please!</P> <P>&nbsp;</P> Tue, 03 May 2022 13:59:56 GMT https://community.qlik.com/t5/QlikView/Selection-Issue/m-p/1925705#M1218763 BrunPierre 2022-05-03T13:59:56Z https://community.qlik.com/t5/QlikView/Selection-Issue/m-p/1925859#M1218767 <P><SPAN>RANGESUM(BELOW(SUM(DailyInterest),0,rowno())) + SUM(Interest)</SPAN></P> <P><SPAN>can you try above one</SPAN></P> Tue, 03 May 2022 19:47:21 GMT https://community.qlik.com/t5/QlikView/Selection-Issue/m-p/1925859#M1218767 anat 2022-05-03T19:47:21Z https://community.qlik.com/t5/QlikView/Selection-Issue/m-p/1925899#M1218769 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47358">@anat</a> it produces the same outcome as before.</P> Tue, 03 May 2022 20:45:58 GMT https://community.qlik.com/t5/QlikView/Selection-Issue/m-p/1925899#M1218769 BrunPierre 2022-05-03T20:45:58Z