Selection Issue

MiguelHathaway — Fri, 03 Jun 2022 05:06:17 GMT

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).

My challenge is whenever I select any subsequent date, the amount defaults to 5,263.25, that's the initial amount as of 25/04/2022. Table without any date selection

Table with 27/04/2022 selection

Apparently, in the above scenario, the amount should read 5,409.45 and not 5,263.25. Tim Hortons Survey

Help me out here, please!

Table with Daily Interest column

Re: Selection Issue

vinieme12 — Fri, 03 Jun 2022 05:03:40 GMT

Ignore the date selection

=Aggr(RANGESUM(BELOW(SUM({<Date=>}DailyInterest),0,NOOFROWS())) , Date)+ SUM(Interest)

topic Re: Selection Issue in QlikView

Selection Issue

Re: Selection Issue