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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator III
Creator III

fiscal calendar

i have the date field like below

date

 

01-01-2017
11-01-2017
01-02-2017
11-02-2017
01-03-2017
11-03-2017
01-04-2017
11-04-2017
01-05-2017
11-05-2017
01-06-2017
11-07-2017
01-08-2017
11-09-2017
01-10-2017
11-11-2017
01-12-2017

11-01-2018

actually the starting date of the month is 01-01-2017.

for all the month  starting date is 1st day

but i want to show the starting date of month is 11th day for all the month

i.e

1-01-2017 to 10-02-2017 is JAN month

11-02-2017 to 10-03-2017 is FEB month

like wise

i want to achieve is in master calendar

Labels (1)
4 Replies
sunny_talwar
MVP
MVP

stephenedberkg
Creator III
Creator III
Author

i want to show the month start and end date

for Jan month month start is 11-01-2017

month end is 10-01-2017

Feb month start is 11-02-2017

end 10-03-2017

like wise....

sunny_talwar
MVP
MVP

That is what the above links show how that can be done. Did you check them out?

stephenedberkg
Creator III
Creator III
Author

thanks for your reply sunny

i want to generate

actual date         fiscal date       month

11-01-2017          1-01-2017      Jan               

12-01-2017          2-01-2047          jan

......

......

.......

10-02-2017         31-01-2017    jan

11-02-2017          01-02-2017    Feb

.......

...

...

like wise i want to create

.