I am trying to create a master calendar which will help me to create a chart for a complete year even if i miss with data for a month.
my month start from Nov of every year.
and my order date column is in a format like "YYYYMM", for ex for nov'16 it is like 201611.
can you please guide me how to create a master calendar for below information
Fiscal year (format FY16)
Fiscal Quarter (format Q1)
month format (Nov)
I have gone through some of the earlier post, but so far not able to achieve this.
In addition to what Sunny has provided please also take a look at:
Let us know how you do.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
thanks for your feedback.
I will follow the provided post.
Any guidance how to get month (jan), fiscalyear(FY16) and Quarter(Q1) out of a code like "201601"
i dont have a order date column. i only have information in a code with a format like "YYYYMM"
I think once you have a mastercalendar, all those things will come out very easily. The only thing you might have to make sure is that the date is read correctly as a date by QlikView. To do this, you can use Date#() function. In your case, may be like this:
Date(MonthStart(Date#(DateFieldName, 'YYYYMM')), 'YYYYMM') as DateField
Now you will use this to create your master calendar which will create all your quarter, year, month, quarteryear fields for you.
If you still continue to feel confused, provide a few lines of data so that we can help you with a sample script