topic Calculate amount different from the selected date in QlikView

Calculate amount different from the selected date

cristianj23a — Sat, 16 Nov 2024 04:57:55 GMT

Hello
I am trying to calculate the amount different to the selected date. The date is accumulated, I mean that if you filter 05/31/2018 you must calculate the amount greater than May.Example:

I am filtering until May of 2018 and I like to import 1,892.12 dollars but it is not what I want.

If you filter until May 2018 you must calculate the amount from June 2018 to the current date, which should be 136.29 dollars.

please help me with this topic.
I attach the qvw.
Greetings.

Re: Calculate amount different from the selected date

sunny_talwar — Thu, 13 Dec 2018 20:54:07 GMT

Try these expression

Importe USD

Sum( {<%OPERACIÓN={'PRESTAMOS'}, MesAño, Fecha. = {"$(='>' & Date(Max(Fecha.), 'DD/MM/YYYY') & '<=' & Date(Today(), 'DD/MM/YYYY'))"},Cuenta.=,Rubros=,[Centro Coste]>}  [Importe USD])

Importe PEN

Sum( {<%OPERACIÓN={'PRESTAMOS'},MesAño, Fecha. = {"$(='>' & Date(Max(Fecha.), 'DD/MM/YYYY') & '<=' & Date(Today(), 'DD/MM/YYYY'))"},Cuenta.=,Rubros=,[Centro Coste]>}  [Importe PEN])