Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner
Partner

YTD with excluding specific days

Hi,

I have calculated YTD by using below link

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

YTQ, QTD, MTD and WTD

But i need to exclude January 1st and 2nd from the calculation.

Is it possible.

Thank You

1 Solution

Accepted Solutions
sunny_talwar

May be this:

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

View solution in original post

2 Replies
sunny_talwar

May be this:

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

View solution in original post

Not applicable

Are you need YTD from weekStart ? Update the YTD flag in the script to compensate tthe weekstart instead of Jan 1st.