Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this may be
Right(Fiscal_Quarter, 2) & Chr(39) & Mid(Fiscal_Quarter, 3, 2)
Try this may be
Right(Fiscal_Quarter, 2) & Chr(39) & Mid(Fiscal_Quarter, 3, 2)
Thank You sunny_talwar,
sunny_talwar