topic hiding data values from list box in QlikView

hiding data values from list box

engr_farhanqadr — Thu, 29 Aug 2013 07:11:50 GMT

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 — Thu, 29 Aug 2013 07:17:00 GMT

Try like this

Listbox -> Expression

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

kaushiknsolanki — Thu, 29 Aug 2013 07:17:18 GMT

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

Thu, 29 Aug 2013 07:17:20 GMT

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 — Thu, 29 Aug 2013 07:23:38 GMT

Dear Farhan,

you can write the expression in list box.

kindly find the attachment.

i hope it will help you.

Thanks,

Mukram.