topic Re: Extracting exact numbers from text field in QlikView https://community.qlik.com/t5/QlikView/Extracting-exact-numbers-from-text-field/m-p/15658#M458073 <HTML><HEAD></HEAD><BODY><P>please post some more sample data and your expected result.</P></BODY></HTML> Sun, 27 May 2018 21:48:44 GMT MarcoWedel 2018-05-27T21:48:44Z Extracting exact numbers from text field https://community.qlik.com/t5/QlikView/Extracting-exact-numbers-from-text-field/m-p/15657#M458072 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>So I have a text field called qualifications.</P><P></P><P>Example:</P><P>BA/BS degree in Computer Science or a related software engineering field, or equivalent practical experience. <SPAN style="font-size: 10pt;">10 years of experience in a technical role. </SPAN><SPAN style="font-size: 10pt;">5 years of experience working within cloud and working with clients across JAPAC in a partner aligned role.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">How do I extract only these years of experience?? I am trying to make a bar chart which consists of:</SPAN></P><P><SPAN style="font-size: 10pt;">dimension - years of experience</SPAN></P><P><SPAN style="font-size: 10pt;">measure - count of years of experience</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I really need help with making the correct expression. </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks!</SPAN><SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Sat, 26 May 2018 17:20:54 GMT https://community.qlik.com/t5/QlikView/Extracting-exact-numbers-from-text-field/m-p/15657#M458072 Anonymous 2018-05-26T17:20:54Z Re: Extracting exact numbers from text field https://community.qlik.com/t5/QlikView/Extracting-exact-numbers-from-text-field/m-p/15658#M458073 <HTML><HEAD></HEAD><BODY><P>please post some more sample data and your expected result.</P></BODY></HTML> Sun, 27 May 2018 21:48:44 GMT https://community.qlik.com/t5/QlikView/Extracting-exact-numbers-from-text-field/m-p/15658#M458073 MarcoWedel 2018-05-27T21:48:44Z