Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
ajinkyabhonsle
New Contributor III

Convert FiscalYearQuarter to Quarter

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?

1 Solution

Accepted Solutions
dwforest
Valued Contributor II

Re: Convert FiscalYearQuarter to Quarter

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

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

View solution in original post

3 Replies
Highlighted
drunk8gods
New Contributor

Re: Convert FiscalYearQuarter to Quarter

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

=right([field],2)

Highlighted
ajinkyabhonsle
New Contributor III

Re: Convert FiscalYearQuarter to Quarter

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
Valued Contributor II

Re: Convert FiscalYearQuarter to Quarter

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

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

View solution in original post