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

Build Calendar

Hi All,

I have a month field and year field but data is like FY-15, FY-16 and no date field . Is it possible to create a calendar with those fields and finally is it possible to calculate YTD's , MTD's and prior year calculations from the calendar created.

Thank you,

AJ

1 Solution

Accepted Solutions
ziadm
Specialist
Specialist

Hi Aj

Attached is a master calendar created out of FY-15,FY-14 fiscal year field

You will not be able to get MTD Sales as you do not have in your fact Table month.  However you can have YTD and PriorYTD

View solution in original post

4 Replies
ziadm
Specialist
Specialist

Yes you can but you will not be able to calculate MTD  measure.  You will only have the YTD and Prior YTD measure. 

The Field value FY-15 contains only year information and no month

Anonymous
Not applicable
Author

Thanks for the replay Ziad. Could you please help me to create the calendar. Thanks in advance.

-AJ   

ziadm
Specialist
Specialist

Hi Aj

Attached is a master calendar created out of FY-15,FY-14 fiscal year field

You will not be able to get MTD Sales as you do not have in your fact Table month.  However you can have YTD and PriorYTD

tomovangel
Partner - Specialist
Partner - Specialist

Creating A Master Calendar

This is a discussion, I didn't know anything about calendars,
And only through the video i got it ..

Good Luck

-Angel