topic Need Help?? in QlikView

Need Help??

Nagaraju_KCS — Fri, 10 Oct 2014 11:05:50 GMT

Hi Community,

How to calculate YTD in fiscal year ...

i am using this expression, but it's not working..

sum({<[Date] = {">=$(=YearStart(max([Date]))) <=$(=max([Date]))"},Year =, Month = >} Amount)

please anyone can help me out..

PrashantSangle — Fri, 10 Oct 2014 11:09:28 GMT

Hi,

Try this,

sum({<[Date] = {">=$(=Date(YearStart(max([Date])))) <=$(=Date(max([Date])))"},Year =, Month = >} Amount)

Regards

senpradip007 — Fri, 10 Oct 2014 11:10:19 GMT

Try like:

sum({<[Date] = {">=$(=YearStart(max([Date]),0,4)) <=$(=max([Date]))"},Year =, Month = >} Amount)

PrashantSangle — Fri, 10 Oct 2014 11:12:29 GMT

Hi,

Considering your Fiscal Year started from April

then use AddMonths() in your expression like,

sum({<[Date] = {">=$(=Date(AddMonths(YearStart(max([Date])),4))) <=$(=Date(max([Date])))"},Year =, Month = >} Amount)

Regards

Fri, 10 Oct 2014 11:14:37 GMT

Expression seems to be correct. you can share your qvw to have a check.