Convert FiscalYearQuarter to Quarter

[ajinkyabhonsle]

Hi Qlik users,

I have a field in my table called FISCALYEARQUARTER with values eg: 2018Q1,2018Q2,2018Q3,2018Q4,2019Q1,2019Q2 etc..

I want to convert this field into Quarters eg: Q1, Q2, Q3.Q4. Can anyone help me how do make the change?

[drunk8gods]

If you're just looking to get the Q1 Q2 etc regardless of year, try using 

=right([field],2)

[ajinkyabhonsle]

Great!. Thank you so much.  Had another question on similar lines. Hope its ok to post here. With the same FISCALYEARQUARTER i want to create a field called Fiscal Year like FY18, FY19, FY20 etc...How can we do that?

[dwforest · Accepted solution]

='FY' + Mid(FISCALYEARQUARTER ,3,2)

online help is your friend  --- help.qlik.com

[DeeC84]

Hi

I have the opposite issue, I have FiscalQuarter (Q1,Q2 etc)  and am trying to create FiscalYearQuarter (2019Q1, 2019Q2 etc). Please help! 

[Dharanidharan_DD]

Hi @DeeC84 

Try This,

Year(YearEnd([DateField],0,4)) & [FiscalQuarter]