topic Re: Search in table box in QlikView

Search in table box

fashid — Mon, 23 Mar 2015 06:06:48 GMT

Hi,

I have several table boxes which works as data dump.

I have a created a search box for searching.

But the issue is, i want the search box to work only on the table box which is currently maximised and search those fields which are present in that tablebox for that particular string and not like an associative search.

For eg if i search for a name it should only filter if that name if it exists in the table box.

Regards,

Nadeem Shaikh

Re: Search in table box

Mon, 23 Mar 2015 09:10:39 GMT

Hi Naddem,

There are few indirect options that you can try out:

1. Instead of Seach box you can use internal selection for every table .

for every table box -> Right click go to properties-> presentation tab ->check in 'Drop-down select' it will enable dimension selection on table box.

2. Use Alternative state - Set a separate state for selection box and the table box you need to filter it.

Regards

Lathaa

Re: Search in table box

fashid — Tue, 24 Mar 2015 06:43:48 GMT

Hi Latha ,

Thanks for replying .

So i guess its not possible to have it the way i want

Regards,

Nadeem

Re: Search in table box

jonathandienst — Tue, 24 Mar 2015 06:50:40 GMT

You can restrict a search box to search a subset of fields. Check the option 'List of Fields' and choose the table box fields. You might want to change the 'Text on Search Field' option on the Presentation tab.

HTH

Jonathan

Re: Search in table box

Tue, 24 Mar 2015 06:51:35 GMT

Yeah Even I guess the same but Is it a mandatory req from business side?

Regards

Lathaa

Re: Search in table box

fashid — Tue, 24 Mar 2015 07:33:35 GMT

Hi Jonathan,

Thanks for your time .

I Actually thought about this 'List of Fields' option but as i have multiple table boxes with diferent fields.hence it won't be possible .

I guess i just have to educate the customer about this .

Regards,

Nadeem

Re: Search in table box

fashid — Tue, 24 Mar 2015 07:34:25 GMT

Nope Latha it was just the way they wanted the search box to behave .

Regards,

Nadeem