question on mtd,ytd,pytd

[d_koti24]

how to write expressions for mtd,ytd,pytd,qtd?

regards,

koti

[MK_QSL]

MTD

=SUM({<InvoDate = {">=$(=MonthStart(Max(InvoDate)))<=$(=MonthEnd(Max(InvoDate)))"}>}Sales)

YTD

=SUM({<InvoDate = {">=$(=YearStart(Max(InvoDate)))<=$(=Max(InvoDate))"}>}Sales)

PYTD

=SUM({<InvoDate = {">=$(=YearStart(Max(InvoDate),-1))<=$(=YearEnd(Max(InvoDate),-1))"}>}Sales)

QTD

=SUM({<InvoDate = {">=$(=QuarterStart(Max(InvoDate),-1))<=$(=QuarterEnd(Max(InvoDate),-1))"}>}Sales)

Change Max(InvoDate) to Today() if you want to get all these results with respect to Today

[#3]

Hi,

try something like this:

Sum({<YearField = {$(#=Max(YearField))},MonthField = {"<=$(#=Num((Max(MonthField)))"} >} myField) // YTD

Sum({<YearField = {$(#=Max(YearField))},MonthField = {$(#=Num(Max(MonthField)))}, DayField = >} myField) // MTD

Best regards.

[maxgro]

YTD and previous YTD

Previous YTQ, QTD, MTD and WTD

YTD

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