topic Re: search in qv can filter only display certain table data ? in QlikView

search in qv can filter only display certain table data ?

paulyeo11 — Sun, 07 Jul 2013 01:45:46 GMT

Hi All

when i search for MY2 , this items have it in sales table , inventory table , opportunity table , inventory table.

but since the particular sheet is for user search for inventory table.

how can i limit the search only display items appear from inventory table ?

now is very confuse , as it list all table.

any work around ?

Re: search in qv can filter only display certain table data ?

swuehl — Sun, 07 Jul 2013 08:30:43 GMT

You can limit the search to certain fields in search object properties.

When you perform a search on a key field, you won't be able to limit it to a certain table, I believe.

If that's the issue here, you can potentially duplicate the key field values in that table, creating another field for searching that particular table.

Re: search in qv can filter only display certain table data ?

paulyeo11 — Sun, 07 Jul 2013 09:02:26 GMT

Hi swuehl

many thank for yr sharing.