Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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.

View solution in original post

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.