Discussion board where members can get started with Qlik Sense.
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
View solution in original post
If you're just looking to get the Q1 Q2 etc regardless of year, try using
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?