topic Date functions in QlikView

Date functions

Anonymous — Tue, 08 Jul 2014 16:37:05 GMT

Can you please help me YTD() and MTD() functions with examples?

ashfaq_haseeb — Tue, 08 Jul 2014 16:55:44 GMT

HI,

Look at the below post.

Regards

ASHFAQ

maxgro — Tue, 08 Jul 2014 16:57:32 GMT

here a good example, using load script (master calendar) and set analysis

Anonymous — Thu, 10 Jul 2014 18:20:24 GMT

Hi.............

Thanx for ur reply............

Suppose date selected is 21-03-2014 then YTD is 01-01-2014 to 21-03-2014.What is the

MTD(21-03-2014)=?

WTD(21-03-2014)=?

Please help me?

maxgro — Thu, 10 Jul 2014 18:27:09 GMT

Month to date. The period of time from the 1st of the month until the current date. If current date is 21-03-2014

MTD = 01-03-2014

Week to date from the beginning of the week in which the date falls in, to the date

its_anandrjs — Thu, 10 Jul 2014 18:31:09 GMT

Basic YTD and MTD calculation done by variables or SET expression you can try like

YTD Calculation:-

Sum({$< YourDatefield = {'>$(=Max((YearStart(YourDatefield)))) <=$(=Max(Today()))'}>} Metrics)

Sum({$<Datefield = {'>$(vYearStart) <=$(vCurrentMonth)'}>} Metrics)

MTD Calculation:-

Sum({$<YourDatefield = {'>=$(=Max((MonthStart(YourDatefield)))) <=$(=Max(YourDatefield))'}>} Metrics)

Sum({$<YourDatefield = {'>=$(=Max((MonthStart(Today())))) <=$(=Max(today()))'}>} Metrics)

its_anandrjs — Fri, 11 Jul 2014 19:17:01 GMT

If you got correct answer from the thread so mark the thread as correct / Helpful for references

Regards,

Anand