Re: Need Help?? - Qlik Community

Nagaraju_KCS · ‎2014-10-10

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 · ‎2014-10-10

Hi,

Try this,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

senpradip007 · ‎2014-10-10

Try like:

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

PrashantSangle · ‎2014-10-10

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-10-10

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

Need Help??

Related Topics