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: 
Anonymous
Not applicable

Mtd,Ytd

Hi All,

I am working on ytd,mtd calcuation in script level.

Below is my script.

I am getting the day values which are correct .But my ytd ,mtd are wrong values.Please correct if my formula is wrong.

Load *, 'YTD' as TimeGranule

Resident Cal where Date >=YearStart(TempDate) and Date<=TempDate;

Load *, 'MTD' as TimeGranule

Resident Cal where Date >= MonthStart(TempDate) and Date <= TempDate;

Load * , 'Day' as TimeGranule

Resident Cal

where Date=TempDate;

Thanks

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

Have a look here:

Relative Calendar Fields

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein