Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ravindraa
Creator
Creator

Master calendar issue

Hi all,

   I have struck one place please give me any suggestion to come out.

i have created master calendar as per normal but here i have to create master calendar like below

YTD ---> should be start 2 Apr to next year 1st Apr ======> 2 Apr-2015  to  1-Apr-2016

MTD---> should be start 2nd day of month to next month 1 day =====> 2 Mar-2016  to  1-Apr-2016

QTD ---->should be start 2 nd day of the quarter start to 1st day of the  next quearter===>2 Jan-2016  to  1-Apr-2016.

YTD flag also should be display same scenario

MTD flag also should be display same scenario

QTD flag also should be display same senatio

Please give any suggestion to come out this.

thanks In advance.

3 Replies
sunny_talwar

Have you may be thought of exploring these options?

Fiscal and Standard Calendar generation

Fiscal Year

ravindraa
Creator
Creator
Author

Hi Sunny Thanks for replay ,

  but  if it is Month the day should be start 2nd day of month and end with next month 1 st day.

if it is Quearter the day should be start 2nd day of Quearter and end with next quearter 1 st day.

if it is year the day should be start 2nd day of year and end with next year 1 st day.

Please give me any suggestion to come out.

marcus_sommer

Maybe this is more suitable: Fiscal Calendar with Non-Standard Days (Not 1-31)

- Marcus