Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ajvemp10
New Contributor

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
Valued Contributor

Re: Build Calendar

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

4 Replies
ziadm
Valued Contributor

Re: Build Calendar

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

ajvemp10
New Contributor

Re: Build Calendar

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

-AJ   

ziadm
Valued Contributor

Re: Build Calendar

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

Partner
Partner

Re: Build Calendar

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