topic Re: How to display only limited values in list box? in QlikView

How to display only limited values in list box?

Thu, 06 Mar 2014 15:52:20 GMT

Hi,

I have column as list box . The values are Soaps, Clothes, Bats, Pens, 1,4342,4435,7423847,4783274283,67,9,10,11,12

How can I make available to display only Soaps, Clothes, Bats, Pens?

Thanks.

MK_QSL — Thu, 06 Mar 2014 15:55:33 GMT

Write below expression in your list box

=IF(NOT IsNum(Value),Value)

UPDATE : Check enclosed file..

alexandros17 — Thu, 06 Mar 2014 15:58:06 GMT

Write instead of your field the expression (you find the item menu expression at the end of the list of fields)

if(myField = 'Soaps' or myField = 'Clothes' or myField = 'Bats' or myField = 'Pens', myField, null())

hope it helps

Thu, 06 Mar 2014 15:58:43 GMT

Thanks where I need to give is it

expression-> show-> conditional

Thu, 06 Mar 2014 16:00:21 GMT

you can create another field like this in dm or you can write similar expression in list box but its not performance effective

load if(isnum(TestField)=0,TestField) as TestField;

Load * inline

[

TestField

Soaps

Clothes

Bats

Pens

4342

4435,

7423847

];

Thu, 06 Mar 2014 16:00:25 GMT

Thanks and that's perfect.