topic Re: SET FirstMonthOfYear=5; in QlikView

SET FirstMonthOfYear=5;

Fri, 24 Jul 2015 19:30:45 GMT

I've got SET FirstMonthOfYear=5; in my load editor, but then I use:

QuarterName(PAL_Acceptance_Date) As Accept_QuarterName,

and it still puts Jan-Mar 2020 for a 1/1/2020 date. It is as if it is not seeing the change in the first month. Any ideas?

Re: SET FirstMonthOfYear=5;

Fri, 24 Jul 2015 19:33:19 GMT

Sorry. I forgot to add.

Dual('Q' & Ceil(Month(PAL_Acceptance_Date)/3), Ceil(Month(PAL_Acceptance_Date)/3)) as Accept_Quarter,

QuarterName(PAL_Acceptance_Date) As Accept_QuarterName,

result is Q1...rather than Q3.

Re: SET FirstMonthOfYear=5;

Fri, 24 Jul 2015 20:34:18 GMT

I also tried:

'Q' & Ceil(Month(PAL_Acceptance_Date)/3) as Accept_Quarter,

Still getting Q1 for what should be Q3 in our world.

Re: SET FirstMonthOfYear=5;

sunny_talwar — Fri, 24 Jul 2015 20:44:48 GMT

What if you do this:

'Q' & Ceil(((If(Num(Month(PAL_Acceptance_Date)) < 5, Num(Month(PAL_Acceptance_Date)) + 8, Num(Month(PAL_Acceptance_Date)) - 4)/3) as Accept_Quarter,

Re: SET FirstMonthOfYear=5;

maxgro — Fri, 24 Jul 2015 20:51:09 GMT

for fiscal quarter calc

Fiscal and Standard Calendar generation

Re: SET FirstMonthOfYear=5;

Fri, 24 Jul 2015 21:27:50 GMT

good idea! I just started a similar vein by adding 4 but hadn't gotten to the point about thiking about 12+4, etc. would not work.

just doctored the parethesis and it worked. thank you!

'Q' & Ceil((If(Num(Month(PAL_Acceptance_Date)) < 5, Num(Month(PAL_Acceptance_Date)) + 8, Num(Month(PAL_Acceptance_Date)) - 4)/3)) as Accept_Quarter,

Still not sure why firstmonthofyear does not seem to work though.

Re: SET FirstMonthOfYear=5;

sunny_talwar — Fri, 24 Jul 2015 21:33:33 GMT

‌No reward for proposing the idea for using if statement ?

Just kidding. I am glad I wss able to guide you in the right direction.

Best,

Sunny

Re: SET FirstMonthOfYear=5;

Fri, 24 Jul 2015 21:39:09 GMT

Where's your gofundme? You saved me a good hour or longer.