topic Re: fiscal calendar in QlikView

fiscal calendar

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

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

sunny_talwar — Tue, 06 Feb 2018 12:50:16 GMT

check here

stephenedberkg — Tue, 06 Feb 2018 12:57:24 GMT

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 — Tue, 06 Feb 2018 12:59:25 GMT

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

stephenedberkg — Tue, 06 Feb 2018 13:12:20 GMT

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