Selections Issue

[dmohanty]

Hi,

Here is a sample data set -

Color	Fruit
Yellow	Banana
Yellow	Mango
Red	Grapes
Red	Berry
Green	Grapes
Green	Banana

I have created filter/list box expression -

if(
Match(Color, ’Yellow’)
or
Match(Color, ’Green’) 
,
‘Favorite Fruit’

)

Once I select the filter 'Favorite Fruit' (LED Green Check Box enabled), data narrows down to -

Color	Fruit
Yellow	Banana
Yellow	Mango
Green	Grapes
Green	Banana

Now if I select 'Banana' , the filter 'Favorite Fruit' stays unhampered, as Banana falls in both Green and Yellow.

But if I select 'Grapes' or 'Mango', the filter 'Favorite Fruit' gets cleared - Means the LED Check mark disappears, but in th current selection box still the Color shows as Yellow, Green.

Need -

For the scenario like I did for 'Grapes' or 'Mango', my LED Check Mark SHOULD NOT vanish and Current Selection Box to show the respective Color (even though its a single color).

Please suggest the expression to modify.

Regards!

[swuehl · Accepted solution]

Try

=Aggr(

if(

Match(Color, 'Yellow')

or

Match(Color, 'Green') 

,

'Favorite Fruit')

,Color)

[dmohanty]

Hi swuehl‌,

Thank you. Cool. 

I tried putting the Aggr function - but for all other fields except 'Color'.

Even though it keeps the Filter unhampered now, but the Current Selection Box still has two values. But that's fine for me.

If we can work on that, would be great otherwise not a priority though!