Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cristianj23a
Partner - Creator III
Partner - Creator III

Calculate amount different from the selected date

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.

Captura.PNG

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

 Captura.PNG

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

 

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
Labels (1)
2 Replies
Anil_Babu_Samineni

What is the date field?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
uacg0009
Partner - Specialist
Partner - Specialist

Hi Cristianjmr,

Is that what you want? Please see my attachment.

Calculate amount different from the selected date.PNG

Aiolos