Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kamalqlik
Partner - Specialist
Partner - Specialist

Query

I am having one query. The lines that I am pasting here is most frequently

used here but I am not understand this logic. So can you elaborate the

output coming from this. Basically I want to be clear about YTD and MTD

functions. Here:

Year = 2011, 2012

Month = 1,2,3,4,....,12

Maxdate = Date(today()-1,'YYYY-MM-DD')

.         Here I am having 1 doubt that the date format of Maxdate is

YYYY-MM-DD but at other places we are using date format as dd/mm/yyyy.

FiscalMonthStart = 4

If(InYearToDate (date(makedate(Year,Month,1),'dd/mm/yyyy'),'$(MaxDate)',

0,$(FiscalMonthStart)),1,0) as [TYTD  Flag Budget],  //   Current Year to

Date this Year

If(InYearToDate (date(makedate(Year,Month,1),'dd/mm/yyyy'),'$(MaxDate)',

-1,$(FiscalMonthStart)),1,0) as [LYTD  Flag Budget], //  Last Year to Date

this Year

If(InYear (date(makedate(Year,Month,1),'dd/mm/yyyy'),'$(MaxDate)',

-1,$(FiscalMonthStart)),1,0) as [LY  Flag Budget],         // All Dates Last

Year

//******************Month

Flag******************************************************************

If(InMonthToDate(date(makedate(Year,Month,1),'dd/mm/yyyy'),'$(MaxDate)',

0,$(FiscalMonthStart)),1,0) as [TY CMTD Flag Budget], //   Current Month to

Date this Year

If(InMonthToDate(date(makedate(Year,Month,1),'dd/mm/yyyy'),'$(MaxDate)',

-1,$(FiscalMonthStart)),1,0) as [TY PMTD Flag Budget] //  Previous Month to

Date this Year

Please revert asap I am waiting for your reply.

0 Replies