Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
='FY' + Mid(FISCALYEARQUARTER ,3,2)
online help is your friend --- help.qlik.com
If you're just looking to get the Q1 Q2 etc regardless of year, try using
=right([field],2)
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?
='FY' + Mid(FISCALYEARQUARTER ,3,2)
online help is your friend --- help.qlik.com
Hi
I have the opposite issue, I have FiscalQuarter (Q1,Q2 etc) and am trying to create FiscalYearQuarter (2019Q1, 2019Q2 etc). Please help!