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

[swuehl]

There actually is a LIKE string operator in QV.

=if(FIELD like 'y_*', FIELD)

[kouroshkarimi · Accepted solution]

Ok sorry I didnt read the first post properly. You want something like if(WildMatch($Field,'Y_*')=1,$Field,null())

[kouroshkarimi]

Rename it in the properties on the listbox. If it's in the script then use the statement Rename Field $Field to NewField;

[#5]

Thank you

Regards,

Prajna

[#6]

Hi,

But in list box we dnt have option to rename field... ??

I want to access $(Field ) in 2 places... so I want to give two names for this so that there will be no association.

Regards,

Prajna