slipper object get maximum date

cristianj23a — Sat, 16 Nov 2024 04:56:20 GMT

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.

Re: slipper object get maximum date

sunny_talwar — Tue, 18 Dec 2018 15:57:55 GMT

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

topic Re: slipper object get maximum date in QlikView

slipper object get maximum date

Re: slipper object get maximum date