Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SET FirstMonthOfYear=5;

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?

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

7 Replies
Not applicable
Author

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.

Not applicable
Author

I also tried:

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

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

sunny_talwar

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,

maxgro
MVP
MVP

Not applicable
Author

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.

sunny_talwar

‌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

Not applicable
Author

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