topic Re: what is MTD,YTD,QTD and YOY works? in QlikView

what is MTD,YTD,QTD and YOY works?

Karim_Khan — Wed, 05 Aug 2015 08:55:54 GMT

Pls help

Re: what is MTD,YTD,QTD and YOY works?

Anonymous — Wed, 05 Aug 2015 08:58:22 GMT

MTD -Month to Date

YTD - Year to Date

QTD - Quarter to Date

YOY - Year on Year

Re: what is MTD,YTD,QTD and YOY works?

Wed, 05 Aug 2015 09:00:00 GMT

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

Re: what is MTD,YTD,QTD and YOY works?

Karim_Khan — Wed, 05 Aug 2015 09:00:21 GMT

what is the login and how its work

Re: what is MTD,YTD,QTD and YOY works?

rubenmarin — Wed, 05 Aug 2015 09:05:06 GMT

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)

Re: what is MTD,YTD,QTD and YOY works?

Karim_Khan — Wed, 05 Aug 2015 09:05:23 GMT

Hi Joe,

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

Regards,

Re: what is MTD,YTD,QTD and YOY works?

Karim_Khan — Wed, 05 Aug 2015 09:06:56 GMT

Thank you very much Ruben

Re: what is MTD,YTD,QTD and YOY works?

buzzy996 — Wed, 05 Aug 2015 09:28:52 GMT

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.

Re: what is MTD,YTD,QTD and YOY works?

kuczynska — Wed, 05 Aug 2015 09:39:48 GMT

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

Re: what is MTD,YTD,QTD and YOY works?

kavita25 — Wed, 05 Aug 2015 09:55:51 GMT

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