Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

capriconuser
New 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
pradosh_thakur
Honored Contributor II

Re: wildcard in dimension

if(left(field_name,2)='CO','CO',IF(LEFT(field_name,2)='DF','DF',field_name))
Learning never stops.
3 Replies
pradosh_thakur
Honored Contributor II

Re: wildcard in dimension

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

Re: wildcard in dimension

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

Re: wildcard in dimension

Or this:

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