topic Re: YtD in QlikView

YtD

Sat, 14 Feb 2015 10:08:46 GMT

Hi to All.

I have confusion following calculation

I want find YTD, Please help me out this issue.

Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} Sales)

Here what can i use instead of DateField and DateNum

Please explain to me

I have Date field like "BILLDATE".

Where can i mention in above expression.

I have two variables like (1).vStartDate

(2).vEndDate

and i have fields like MinOrddate & MaxOrdDate in script.

Please form an expression for YTD by using above values.

Please help me out this issue.

Thanks in Advance

Regards

Chandra.

MK_QSL — Sat, 14 Feb 2015 10:30:24 GMT

SUM({<

Year =, Quarter=, Month=, Week=, BILLDATE=,

BILLDATE={">=$(=Date(YearStart(Max(BILLDATE))))<=$(=Date(Max(BILLDATE)))"}

>}Sales)

Sat, 14 Feb 2015 10:53:43 GMT

Hi Manish,

Thanks for your reply.

Can you Please give me MTD & WTD also.

i cant able get that.

please help me out this issue

Thanks in advance.

MK_QSL — Sat, 14 Feb 2015 14:37:19 GMT

MTD

SUM({<

Year =, Quarter=, Month=, Week=, BILLDATE=,

BILLDATE={">=$(=Date(MonthStart(Max(BILLDATE))))<=$(=Date(Max(BILLDATE)))"}

>}Sales)

WTD

SUM({<

Year =, Quarter=, Month=, Week=, BILLDATE=,

BILLDATE={">=$(=Date(WeekStart(Max(BILLDATE))))<=$(=Date(Max(BILLDATE)))"}

>}Sales)