Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

4 Replies
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

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

.