Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sambrown
Contributor II
Contributor II

Exclude items from straight table search

Hi,

I thought this would be an easy thing to find out about, but I can't find anything!

Just a simple example to work with here.

LOAD * Inline [

Food, Stock

Apples, 26

Pears, 45

Cucumbers, 0

Tangerines, 465

Peaches, 35

Melons, 0

Oranges, 478

Lemons, 0

Tomatoes, 47

Yams, 125];

I create a straight table as a visualisation with 'Food' as a dimension and 'Stock' as a measure and set the limitation of "Stock > 0" so my resulting table will not have Cucumbers, Lemons and Melons. I've taken out Others.

However, when I go to the search magnifying glass at the top of the table. The three items which I have asked to be hidden are still showing in the drop down box. So I can select Melons, but the resulting table will be blank.

My question is, is there a way I can hide things from the search function, like I have with the table itself?

Message was edited by: Samuel Brown Changed title to make more sense

1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

rather than use limitation make the dimension a calcuated one in master items.

something like

if(aggr(sum(Stock), Food)>0, Food, null())

Then exclude nulls from your table and your search should be resitricted as you want.

Regards

Andy

View solution in original post

2 Replies
ogster1974
Partner - Master II
Partner - Master II

rather than use limitation make the dimension a calcuated one in master items.

something like

if(aggr(sum(Stock), Food)>0, Food, null())

Then exclude nulls from your table and your search should be resitricted as you want.

Regards

Andy

sambrown
Contributor II
Contributor II
Author

Thank you so much, now hopefully I can change this thread's title to make more sense!