Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

colville
New Contributor

Convert YYYY to YY on a calculated field

I currently have the following calculated field 'Q' & Ceil(Month([Activity Month])/3) &'  '& 'FY'&((Year([Activity Month]))+1) which purpose is to show the data in the following way Q1 FY18 or FY19 according to the year but instead it's showing as FY2018 or FY2019 i need the best way of converting the year from YYYY to YY so it could show as FY18 or FY19 depending on what is shown on the Activity Month Table.

1 Solution

Accepted Solutions
MVP
MVP

Re: Convert YYYY to YY on a calculated field

May be this

'Q' & Ceil(Month([Activity Month])/3) &'  '& 'FY'& Right(((Year([Activity Month]))+1), 2)

5 Replies
MVP
MVP

Re: Convert YYYY to YY on a calculated field

May be this

'Q' & Ceil(Month([Activity Month])/3) &'  '& 'FY'& Right(((Year([Activity Month]))+1), 2)

colville
New Contributor

Re: Convert YYYY to YY on a calculated field

Thanks for the assistance

colville
New Contributor

Re: Convert YYYY to YY on a calculated field

I also need the Q to start in April which will be month #4 is there any solution which could be applied on the calculated field in the same function above??

MVP
MVP

Re: Convert YYYY to YY on a calculated field

May be this

'Q' & Ceil(Month(AddMonths([Activity Month], -3))/3) &'  '& 'FY'& Right(((Year(AddMonths([Activity Month], -3)))+1), 2)

MVP
MVP

Re: Convert YYYY to YY on a calculated field

Or this

'Q' & Ceil(Month(AddMonths([Activity Month], 9))/3) &'  '& 'FY'& Right(((Year(AddMonths([Activity Month], 9)))+1), 2)

Community Browser