About MTD and YTD

[sarfaraz_sheikh]

Dear All,

I want to develop the report in which i have to calculate Current MTD as well Current YTD ..

How i can make the dynamic logic for the MTD as well As YTD. Please help.

Regards

Sarfaraz

[arulsettu]

hi

check this

YTQ, QTD, MTD and WTD

[amit_saini]

Hi,

Check this:

http://community.qlik.com/docs/DOC-6163

Thanks,

AS

[prma7799]

Hi,

Check this it will help

YTQ, QTD, MTD and WTD

Thanks

Prashant

[its_anandrjs]

Hi,

Check This

For YTD :-

=Sum({<DateField = {'>=$(=Max((YearStart(DateField)))) <=$(=Max(DateField))'}>} Sales)

For MTD :-

=Sum({$<DateField = {'>=$(=Max((MonthStart(DateField)))) <=$(=Max(DateField))'}>} Sales)

Regards

Anand