Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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