topic Re: how to get Like operator functionlity in qlikview in QlikView

how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 09:25:52 GMT

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

Re: how to get Like operator functionlity in qlikview

Anonymous — Fri, 15 Nov 2013 09:32:07 GMT

Prajna

You could try

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

Best Regards, Bill

Re: how to get Like operator functionlity in qlikview

luciancotea — Fri, 15 Nov 2013 09:37:39 GMT

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

Re: how to get Like operator functionlity in qlikview

somenathroy — Fri, 15 Nov 2013 09:49:44 GMT

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

Regards,

Som

Re: how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 10:28:52 GMT

HI,

I Tried this..

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

Regrads,

Prajna

Re: how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 10:31:10 GMT

Hi,

I tried this.. em getting 0 and 1

What might be the mistake

WildMatch($Field,'Y_*')

Regards,

Prajna

Re: how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 10:33:46 GMT

Hi All,

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

Regards,

Prajna

Re: how to get Like operator functionlity in qlikview

kouroshkarimi — Fri, 15 Nov 2013 10:36:39 GMT

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

Re: how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 10:42:03 GMT

Hi,

But em getting both yes and no

here is my fields

Re: how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 10:43:11 GMT

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

Regards,

Prajna

Re: how to get Like operator functionlity in qlikview

swuehl — Fri, 15 Nov 2013 10:46:56 GMT

There actually is a LIKE string operator in QV.

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

Re: how to get Like operator functionlity in qlikview

kouroshkarimi — Fri, 15 Nov 2013 10:50:07 GMT

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

Re: how to get Like operator functionlity in qlikview

kouroshkarimi — Fri, 15 Nov 2013 10:51:20 GMT

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

Re: how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 10:53:39 GMT

Thank you

Regards,

Prajna

Re: how to get Like operator functionlity in qlikview

Fri, 15 Nov 2013 10:58:51 GMT

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