topic Re: How to exclude values from List Box in QlikView

How to exclude values from List Box

Tue, 28 Aug 2012 08:19:22 GMT

How to easily exclude unwanted values from List Box Window. Here is a list of values taken directly from datasource. How to hide some values that I don't want to see, for example -1,1,2,3,4,5. The rest should be visible.

I bet there is an easy way to do this. Thanks.

Re: How to exclude values from List Box

whiteline — Tue, 28 Aug 2012 08:31:25 GMT

You can always use an expression for list box.

For example: =if(pcg_main_cat_i>5, pcg_main_cat_i, null())

Re: How to exclude values from List Box

nilesh_gangurde — Tue, 28 Aug 2012 08:46:48 GMT

Hiii Pawel,

You can use the below expression to hide

the specific value from List box (i.e. Number as well as String value)

if(pcg_main_cat_i <> '1' or pcg_main_cat_i <> '2' or pcg_main_cat_i <> '3' or pcg_main_cat_i <>'4' or

pcg_main_cat_i <> '5',pcg_main_cat_i)

Regards,

Nilesh Gangurde

Re: How to exclude values from List Box

jchoucq — Tue, 28 Aug 2012 09:01:05 GMT

hi,

to avoid creating IF expression in your list, i think you'd better create, in your script, another field which will contain only the values you want.

Then, it will be so easy to create a Selection list on this new Field.

Regards

Re: How to exclude values from List Box

senpradip007 — Tue, 28 Aug 2012 09:07:15 GMT

Hi pawel.sabaj

You can use the following expressions

if(pcg_main_cat_i>5, pcg_main_cat_i)

Regards

PRADIP