Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
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
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?

Highlighted
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