topic Re: Build Calendar in QlikView

Build Calendar

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Build Calendar

ziadm — Thu, 27 Jul 2017 20:45:14 GMT

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

Re: Build Calendar

Anonymous — Thu, 27 Jul 2017 21:09:51 GMT

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

-AJ

Re: Build Calendar

ziadm — Fri, 28 Jul 2017 06:33:38 GMT

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

Re: Build Calendar

tomovangel — Fri, 28 Jul 2017 08:15:39 GMT

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