topic Re: hOW TO Restrict values in listbox? in QlikView

hOW TO Restrict values in listbox?

Wed, 03 Jul 2013 09:55:16 GMT

i have list box contains below values

fy 2001

fy 2002

now i want remove 'fy'

output

fy 2001

fy 2002

Thnks

Re: hOW TO Restrict values in listbox?

alexandros17 — Wed, 03 Jul 2013 09:58:27 GMT

In the list box instead of field use expression (is at the bottom of the fields list)

and write: mid(myField,3)

where myField is the field containing fy 2001 ...

Re: hOW TO Restrict values in listbox?

Gysbert_Wassenaar — Wed, 03 Jul 2013 10:08:21 GMT

Try using an expression instead of the field name for the listbox: =if(MyField='fy',null(),MyField). Replace MyField with the name of the field you want to show in the listbox. If the value you want to suppress contains spaces you can try =if(trim(MyField)='fy',null(),MyField)

Re: hOW TO Restrict values in listbox?

Sokkorn — Wed, 03 Jul 2013 10:10:19 GMT

Hi,

You can get your job done by using expression in your list box. I have two types. Let try

1. =Aggr(Only({1<Field -= {'fy'}>} Field),Field)

2. =If(Field='fy',Null(),Field)

Regards,

Sokkorn