topic Re: question on mtd,ytd,pytd in QlikView

question on mtd,ytd,pytd

d_koti24 — Wed, 05 Nov 2014 17:52:26 GMT

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

regards,

koti

MK_QSL — Wed, 05 Nov 2014 18:04:13 GMT

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

Wed, 05 Nov 2014 18:11:26 GMT

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 — Wed, 05 Nov 2014 19:49:35 GMT

YTD and previous YTD

YTD