Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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
Master II
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
Master II
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

sambrown
Contributor II
Contributor II
Author

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