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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Help needed ! on Backend Script

Hi All , 

I have column with following fields , 

CO1234

CO4567

COTERS

CO7654

COXYZ

CONTRACT 12345

CO456

 

i need to mark all the fields with starting CO and then numerical numbers ( from starting with 3rd position ) . Please help

i gave WildMatch([Article Number],'CO*') and keepchar([Article Number],'123456789')  I'm getting the values but iam getting with CONTRACT 12345 value ( in which i dont need this )

 

Advance thanks

1 Reply
bramkn
Partner - Specialist
Partner - Specialist

match(left(Article Number,2),'CO') and isnum(mid(Article Number,2,1))

you can also use your wildmatch to replace the match.