Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you so much, now hopefully I can change this thread's title to make more sense!