sum until today

[#1]

First sorry for bad english.

Now problem:

I have two excel spreadsheet with accounting entry. One is for this year from beginning until last working day, and one is all entry in past year. I am working report which will compare performance of this year and last year. I need to sum all amounts from beginning of year to current day. The current day is day when I opened QlikView. I need one expression for current year and one for last year.

Thank you

[ashfaq_haseeb · Accepted solution]

Hi,

look at the attached application

sum({<Year={$(vMaxYear)},Period={'<=$(vMaxDate)'},Month=>}Amount)

Replace vMaxDate by vToday

Regards

ASHFAQ

[senpradip007]

Ashfaq is right. If you are using Quarter in GUI then use the following expression:

sum({<Quarter=,Month=Year={$(vMaxYear)},Period={'<=$(vMaxDate)'}>}Amount)