Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
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')