topic sum until today in QlikView

sum until today

Sun, 25 May 2014 15:53:00 GMT

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

Re: sum until today

ashfaq_haseeb — Mon, 26 May 2014 06:34:28 GMT

Hi,

look at the attached application

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

Replace vMaxDate by vToday

Regards

ASHFAQ

Re: sum until today

senpradip007 — Mon, 26 May 2014 07:07:39 GMT

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

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