Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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