how to get Like operator functionlity in qlikview

[#1]

hi All,

Can we load only those value to a list box where data like y_ ???

WE have like operator in sql can I have  similar functionality? 

if I want to have fields with 'y_' how to filter in listbox-general-field-expression

I don't want in edit script

Thank you

Regards,

Prajna

[Anonymous]

Prajna

You could try

     if ( left ( [YourField] , 2 ) = 'y_' , ..................

Best Regards,     Bill

[luciancotea]

=if( Index( YourField, 'y_' ), 'Yes', 'No' )

[somenathroy]

Use WildMatch(<FieldName>,'y_*') in expression.

Regards,

Som

[#5]

HI,

I Tried this..

if( Index( $Field, 'Y_' ), 'Yes', 'No' )  it didn't work

Regrads,

Prajna

[#6]

Hi,

I tried this.. em getting 0 and 1

What might be the mistake

WildMatch($Field,'Y_*')

Regards,

Prajna

[#7]

Hi All,

I want a filter criteria to load only those values that begins with 'Y_'

Regards,

Prajna

[kouroshkarimi]

theres no mistake, if wildmatch returns 1 it means it found the Y_* fields. So say if(WildMatch($Field,'Y_*')=1,'Yes','No')

[#9]

Hi,

But em getting both yes and no

here is my fields

[#10]

You have any idea how we can rename $(Field)

Regards,

Prajna