Calculating YTD, LYTD, MTD and LMTD Sales

[Lalita_Rai]

How do I calculate?

YTD, LYTD, MTD  and LMTD Sales (KPI objects) based on "Order Date" considering the present date is 29-Dec-2012. Consider Jan to Dec financial year.

Many Thanks.

[AshutoshBhumkar]

Hello,

You can check below link for expressions.

https://community.qlik.com/t5/QlikView-Documents/Date-Level-Analysis-WTD-MTD-QTD-YTD-Current-Year-Pr...

I have a question regarding Present date as 29-Dec-2012, what does that mean ?

Thanks,

Ashutosh

[Lalita_Rai]

Hi Ashutosh,

Thank you

It is referring to the current date which is 29 dec 2012. This was given to
me as assig from my trainer.

[AshutoshBhumkar · Accepted solution]

In that case, create a calendar till 29-Dec-2012.

Then your max(Date) will be 29-Dec-2012 and you can calculate MTD, YTD from that max date.