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 III
Contributor III

wildcard in dimension

i have a column and in that column i have some data like this 

CO2345

DF34234

now i want if there is CO in starting then i want to rename as CO  and if data has DF at starting then i want only DF in data like this 

CO

DF

 

what should  i do 

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

if(left(field_name,2)='CO','CO',IF(LEFT(field_name,2)='DF','DF',field_name))
Learning never stops.

View solution in original post

3 Replies
Highlighted
Master II
Master II

if(left(field_name,2)='CO','CO',IF(LEFT(field_name,2)='DF','DF',field_name))
Learning never stops.

View solution in original post

Highlighted
Specialist III
Specialist III

if(wildmatch(Column_Name , 'CO*') , 'CO' ,
if(wildmatch(Column_Name , 'DF*') , 'DF' ,
Column_Name
))
Highlighted
MVP
MVP

Or this:

=Pick(WildMatch(Dim,'CO*', 'DF*'), 'CO','DF')