Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YtD

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.

3 Replies
MK_QSL
MVP
MVP

SUM({<

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

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

>}Sales)

Not applicable
Author

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
MVP
MVP

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)