topic Re: Calculate amount different from the selected date in QlikView

Calculate amount different from the selected date

cristianj23a — Sat, 16 Nov 2024 04:57:53 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

Anil_Babu_Samineni — Fri, 14 Dec 2018 05:21:30 GMT

What is the date field?

Re: Calculate amount different from the selected date

uacg0009 — Fri, 14 Dec 2018 07:03:43 GMT

Hi Cristianjmr,

Is that what you want? Please see my attachment.

Aiolos