Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
krivi123
New 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

Re: Extracting exact numbers from text field

please post some more sample data and your expected result.