Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Extracting exact numbers from text field

Hi!

So I have a text field called qualifications.

Example:

BA/BS degree in Computer Science or a related software engineering field, or equivalent practical experience. 10 years of experience in a technical role. 5 years of experience working within cloud and working with clients across JAPAC in a partner aligned role.


How do I extract only these years of experience?? I am trying to make a bar chart which consists of:

dimension - years of experience

measure - count of years of experience


I really need help with making the correct expression.


Thanks!

1 Reply
Highlighted

please post some more sample data and your expected result.