topic Re: YTD,MTD,WTD in QlikView

YTD,MTD,WTD

Sat, 14 Feb 2015 11:31:40 GMT

Hi to All,

I have confusion following calculation

I want find out YTD, MTD and WTD 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 help me out this issue.

Thanks in Advance

Regards

Chandra.

MK_QSL — Sat, 14 Feb 2015 14:39:26 GMT

YTD

SUM({<

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

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

>}Sales)

Use MonthStart instead of YearStart for MTD

and

Use WeekStart instead of YearStart for WTD

Oleg_Troyansky — Sat, 14 Feb 2015 16:43:25 GMT

It will be much easier if you could calculate your YTD, MTD, and WTD flags in the script and use them in Set Analysis. Far simpler and faster.

cheers,

Oleg Troyansky

Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!