How to display Fiscal Quarter in the format of F4 - 2018, F1- 2019 , F2-2019?

[arunqlik2view]

Hi All, 

I have requirement to show the Fiscal Quarters in the below format 

1. For Jan - Mar 2018     = F4 - 2018
2. For Apr - June 2018   = F1 - 2019
3. For July - Sept 2018  =  F2 - 2019 
4. For Oct - Dec 2018     = F3 - 2019 

Please help me to obtain this format in Qlikview. Currently, I have  below syntax which shows the Quarters correctly however, the YYYY part is missing  and yes I do want to see 2019 from Apr to Dec of 2018 year. 

'Q' & Ceil(Month(Relevant_Date)/3),
'Q' & alt (if(Month(Relevant_Date)<4,4),if(Month(Relevant_Date)<7,1),if(Month
(Relevant_Date)<10,2),3) as Quarter,

[uacg0009]

Hi Arun,
The first idea occurred to me is using hard-code. I don't know whether you wanna use or not.
Like:
If(Relevant_Date >= '2018-01-01' and Relevant_Date < '2018-04-01','F4 - 2018',
if(Relevant_Date >= '2018-04-01' and Relevant_Date < '2018-07-01','F1 - 2019',
.....

Thanks.
Aiolos

[arunqlik2view]

Hi Aiolos,

Thanks for the reply. Yes, I don't want to use the hard code way.  I looking forward to use the syntax in the Qlikview Editor, so That  I can use it in Dimensions whenever I want them . 

Thanks,

Arun 

[uacg0009]

Hi,
I don't try it in my scripts, but I think it will work, please try:
if(month(Relevant_Date) < 4,'F4 - ' & Year(Relevant_Date),
if(month(Relevant_Date) < 7,'F1 - ' & Year(Relevant_Date) + 1,
if(month(Relevant_Date) < 10,'F2 - ' & Year(Relevant_Date) + 1,
'F3 - ' & Year(Relevant_Date) + 1)))

Aiolos

[santhiqlik]

Hi,
I hope this should work for you !!
'F' & (Month(AddMonths(QuarterStart(Relevant_Date), -1)) / 3) & ' - ' & Year(AddMonths(MonthStart(Relevant_Date), 9))

[libinanto95]

Hi Arun,

Trying using the following Script

LOAD
Relevant_Date,
'Q' & Ceil (Month(Relevant_Date)/3) as Quarter,
If(Month(Relevant_Date)<4,'F4'&'-'&Year(Relevant_Date),
If(Month(Relevant_Date)<7,'F1'&'-'&Year(AddYears(Relevant_Date,+1)),
If(Month(Relevant_Date)<10,'F2'&'-'&Year(AddYears(Relevant_Date,+1)),'F3'&'-'&Year(AddYears(Relevant_Date,+1)))))as Fiscal Calendar

[arunqlik2view]

Hi , 

Thank for your solution. Your syntax worked for me. 

If(Month(Relevant_Date)<7,'F1'&'-'&Year(AddYears(Relevant_Date,+1)),
If(Month(Relevant_Date)<10,'F2'&'-'&Year(AddYears(Relevant_Date,+1)),'F3'&'-'&Year(AddYears(Relevant_Date,+1)))))as Fiscal Calendar

Thanks & Regards,

Arun 

[arunqlik2view]

Hi , Thanks for the reply. I really appreciate the efforts you have taken. 
I tried this in my Dimension section and it did not work for me.  Please let me if know I should be using this syntax somewhere else. 

Also, please note that my issue got fixed by using the following syntax in the QVW editor which was provided by another contributor like you. 

If(Month(Relevant_Date)<7,'F1'&'-'&Year(AddYears(Relevant_Date,+1)),
If(Month(Relevant_Date)<10,'F2'&'-'&Year(AddYears(Relevant_Date,+1)),'F3'&'-'&Year(AddYears(Relevant_Date,+1)))))as Fiscal Calendar

Once again thanks for all the efforts. 

Thanks & regards,

Arun