Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
aarav021
Contributor III
Contributor III

How to extract only specific characters from a field value

Hi team, I have field named "Year" There is one field value FY  2020-2021 H1. I want to get only Numeric that in this format 121 i.e H1's 1 should come first and then 21 should come. Is this possible in qlik. This is the urgent requirement please help. 

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

=right(Year, 1) & mid(Year, 12, 2)

-Rob