topic Re: Excluded Search in listbox? in QlikView

Excluded Search in listbox?

Thu, 06 Nov 2014 10:08:03 GMT

Hi,

I want to search values in listbox we can use *IND* like this it will give IND related values,if i dnt want only IND Related values what should i do?

MK_QSL — Thu, 06 Nov 2014 10:10:44 GMT

Search By typing IND

Select it

Now right click on List Box Properties

Select Excluded

Anonymous — Thu, 06 Nov 2014 10:12:23 GMT

Rakesh,

You can use a search object for your purpose, limiting it to the field you want to look in.

Marc.

ashfaq_haseeb — Thu, 06 Nov 2014 10:19:07 GMT

or try -IND as search string

Regards

ASHFAQ

Thu, 06 Nov 2014 10:25:31 GMT

Hi Ashfaq,

It is giving if the value start only IND then it is exclude that value.if we have it in middle of the value how?

*ind* it will give the values which is start with 'ind' and in middle also.

ashfaq_haseeb — Thu, 06 Nov 2014 10:34:26 GMT

Hi,

That worked with exact string.

Have a look at attached workaround.

Let me know if that suits.

Regards

ASHFAQ

Thu, 06 Nov 2014 10:51:17 GMT

Hi,

I unable to open this doc plz provide the jpeg of listbox

ashfaq_haseeb — Thu, 06 Nov 2014 10:58:43 GMT

Hi,

Ckeck this

30 is selected and its excluded from result.

You need License to open that file

Regards

ASHFAQ