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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
MVP
MVP

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

-Rob