Using Right and Mid in same line of script

[Akshatraj_Adig]

Hi,

I have a column called 'Fiscal_Quarter' with data like  '2020Q1', '2020Q2', '2020Q3', '2020Q4' '2019Q1', '2019Q2', '2019Q3', '2019Q4'. And I need a column which display data  as Q1'19, Q2' 19, Q1'20, Q2'20 etc...

I've tried to use Right( Fiscal_Quarter,2)&'''&Mid(Fiscal_Quarter,3,2) as display_quarter. But not happening and throwing error.

Please help me get this in Qlik.

Thanks in Advance.

[sunny_talwar · Accepted solution]

Try this may be

Right(Fiscal_Quarter, 2) & Chr(39) & Mid(Fiscal_Quarter, 3, 2)

[Akshatraj_Adig]

Thank You  sunny_talwar, 

 sunny_talwar