what is MTD,YTD,QTD and YOY works?

[Karim_Khan]

Pls help

[Anonymous]

MTD -Month to Date

YTD - Year to Date

QTD - Quarter to Date

YOY - Year on Year

[#3]

Hi Karim,

before posting a question like this, it is worth using the search functionality on the community, you'll see that there are a number of answer already to this topic that are worth reading first.

for instance YTQ, QTD, MTD and WTD

To answer your question

MTD = Month to date

QTD = Quarter to date

YTD = year to date

YOY = Year on year

Joe

[Karim_Khan]

what is the login and how its work

[rubenmarin]

That's abreviatures for:

MTD: Month To Date (01/08/2015-05/08/2015)

YTD: Year To Date (01/01/2015-05/08/2015)

QTD: Quarter To Date (01/07/2015-05/08/2015)

YOY: Year Over Year: (01/01/2014-05/08/2014 compared to 01/01/2015-05/08/2015) (I'm not sure of this)

[Karim_Khan]

Hi Joe,

  Going forward will follow the same.But I wanted to know the Logic of YTD,MTD,QTD and YOY

Regards,

KK

[Karim_Khan]

Thank you very much Ruben

[buzzy996]

those are the aberrations of,

mtd: month to date,--ex,overall the sales for the month

ytd: year to date ----ex,overall the sales for the year

qtd: quater to date--ex,overall the sales for the quarter

yoy:year over year--ex,overall the sales from current yera to previous year.

[kuczynska]

There are plenty of very useful articles and posts in community forum. You can have a look at: Year-over-Year Comparisons or QlikView App: Year To Date Using Set Analysis

[kavita25]

MTD-Month to Date for the current month i.e 1/8/2015 till today's date i.e 5/8/2015.

YTD: Year To Date for the current year i.e if your year is starting from Jan den YTD is 1/1/2015 till today's date 5/8/2015

QTD: Quarter To Date for the current quarter i.e July-Sep, 1/7/2015 till today's date 5/8/2015

YoY is the comparison of this year's number with last year’s.

for more information refer HIC Blog Year-over-Year Comparisons

Regards,

Kavita