topic Re: Using Right and Mid in same line of script in QlikView

Using Right and Mid in same line of script

Akshatraj_Adig — Wed, 23 Jun 2021 12:14:52 GMT

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.

Re: Using Right and Mid in same line of script

sunny_talwar — Wed, 23 Jun 2021 12:22:34 GMT

Try this may be

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

Re: Using Right and Mid in same line of script

Akshatraj_Adig — Wed, 23 Jun 2021 12:43:24 GMT

Thank You sunny_talwar,

sunny_talwar