topic Re: YTD MTD in QlikView

YTD MTD

Wed, 16 Apr 2014 04:03:23 GMT

Hi can any body explain to me ytd ad mtd with example sample data.

Re: YTD MTD

arulsettu — Wed, 16 Apr 2014 05:19:01 GMT

Month-TO-Date(MTD)

In this report data is shown for till date of the current month, for the same date of the previous month, and the same date of the last year of same month.

For Eg : - Today is Mar,26 - so data is shown for Mar,2013(Till 26) , Feb,2013(till 26), Mar,2012(till 26)

Year - To-Date(YTD)

In this report data is shown from the begining of the month to the till date of current month and same for the previous months.

For Eg:- Today is Mar,26 - so data is shown from Jan,2013 to Mar,2013(Till 26) and From Jan,2012 to Mar,2012(Till 26).

Re: YTD MTD

anbu1984 — Wed, 16 Apr 2014 05:27:40 GMT

Check these links

QlikView App: Simple Year To Date Example (Set Analysis)

Re: MTD

Re: YTD MTD

Wed, 16 Apr 2014 05:31:34 GMT

YTD (Year To Date):

Year To date means starting from the start of the year till date.

Like Today is 16-Apr-2014 So it will consider from 1-Jan-2014 till 16-Apr-2014.

MTD (Month To Date):

Month To date means starting from the start of the month till date.

Like Today is 16-Apr-2014 So it will consider from 1-Apr-2014 till 16-Apr-2014.

Hope this will help you..!

Re: YTD MTD

jagan — Wed, 16 Apr 2014 05:31:42 GMT

Hi,

MTD - means Month To Date - for today the date range is 1-Apr-2014 to 16-Apr-2014

YTD - means Year To Date - for today the date range is 1-Jan-2014 to 16-Apr-2014

Set Analysis expressions are

MTD:

=Sum({<DateDimensionName={'>=$(=MonthStart(Today()))<=$(=Today())'}>} MeasureName)

YTD:

=Sum({<DateDimensionName={'>=$(=YearStart(Today()))<=$(=Today())'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

Re: YTD MTD

rajat2392 — Wed, 16 Apr 2014 06:14:34 GMT

MTD- Month To Date

It is the analysis till the date for a particular month that is selected for current year and last year or the year selected and its previous year. If you have provided a date filter also so till that date it will calculate. For ex--

You have selected Month as April and year as 2014, as today is 16, April, so from 1, Apr 2014 - 16, Apr 2014 is compared with 1, Apr 2013 - 16, Apr 2013.

YTD- Year To Date

It is the analysis till the date for a particular Year and Month that is selected with the til same month of last year. For ex--

You have selected Month as March and year as 2014, so from 1, Jan 2014 - 31, Mar 2014 is compared with 1, Jan 2013 - Mar 2013.

Re: YTD MTD

MK_QSL — Wed, 16 Apr 2014 06:55:07 GMT

YTD = Year To Date...

Dimension = Customer

Expression

SUM({$<InvoiceDate = {">=$(=YearStart(Today())) <=$(=Today())"}>}Sales)

MTD = Month To Date

Dimension = Customer

Expression

SUM({$<InvoiceDate = {">=$(=MonthStart(Today())) <= $(=Today())"}>}Sales)

Re: YTD MTD

Wed, 16 Apr 2014 07:00:51 GMT

MTD:

summation of (from start of the month to today) measure

=Sum({<DateDimension={'>=$(=MonthStart(Today()))<=$(=Today())'}>} Measure)

YTD:

summation of (from start of the year to today) measure

=Sum({<DateDimension={'>=$(=YearStart(Today()))<=$(=Today())'}>} Measure)