Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Akshatraj_Adig
Contributor
Contributor

Using Right and Mid in same line of script

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.

Akshatraj_Adig_0-1624450432436.png

 

1 Solution

Accepted Solutions
sunny_talwar

Try this may be

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

View solution in original post

2 Replies
sunny_talwar

Try this may be

Right(Fiscal_Quarter, 2) & Chr(39) & Mid(Fiscal_Quarter, 3, 2)
Akshatraj_Adig
Contributor
Contributor
Author

Thank You