hiding data values from list box

[engr_farhanqadr]

Dear Folks,

please suggest me a way how can I hide data values from list box.

e.g

I want to hide

EFU Life

from

list box:

EFU Life

EFU Life Hierarchy

Muhammad Asghar Chaudhri

Quick response will be highly appreciable.

Regards,

Farhan

[MayilVahanan]

HI

Try like this

Listbox -> Expression

= If(FieldName <> 'EFU Life', FieldName)

[kaushiknsolanki]

Hi,

     Do you mean you dont want to have the said string in the listbox?

     If yes then you can create a new field which doesnt have this value.

     Something like this.

     Load Field,

     if(len(Field)=8,null(),if(left(Field,8)='EFU Life',mid(Field,9,len(Field)-8),Field)) as Field_new

     from xyz;

Regards,

Kaushik Solanki

[#4]

Hi,

In the list box fields, select 'expression', and in the editor, write the following expression:

=aggr(only({1<F1-={'*EFU Life*'}>}F1), F1)

**Where F1 is your field.

**Without the asterics, you will delete only the exact value, hence 'EFU Life Hierarchy' will show up.

Regards,

[mdmukramali]

Dear Farhan,

you can write the expression in list box.

kindly find the attachment.

i hope it will help you.

Thanks,

Mukram.