slipper object get maximum date

[cristianj23a]

Hello,
I am filtering the dates through a sliding object and in this case I filter from the minimum date until May 2018.
When I do I get the correct amount, since I aim to show the largest amount to the maximum date selected and in this case I get the amounts after May 2018.

For example in the image above shows the correct amounts, but when I select a "Préstamo", the value of the amounts changes and that is because the maximum date changes and the goal is to show the amounts after the maximum date selected in the slider, regardless of whether you perform any other filter.

I attach the qvw.
Greetings.

[sunny_talwar · Accepted solution]

Try this

Sum( {<%OPERACIÓN={'PRESTAMOS'},MesAño, Fecha. = {"$(='>' & Date(Max({<Préstamo>}Fecha), 'DD/MM/YYYY') & '<=' & '31/12/9999')"},Cuenta.=,Rubros=,[Centro Coste],[Cl Documento]-={'Y1'}>}  [Importe USD])