Select values matching search criteria with set expressions

[Luca1]

I have read a post about the correct usage of the "Select values matching search criteria" action for buttons.
https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-Sense-action-button-for-selecting-multiple-valu... 

According to that post the correct Syntax to filter the values is " ='(customer1|customer2)'. However, I want to filter based on a set expression that only select customers whose order number is > 10. 
Something like 
{<Count([DISTINCT OrderID])={">=10"}>} Customer

This doesn't work - maybe because the set expression is incorrect or maybe because the button action can't handle the output format.

Thanks for your support!

[vikasmahajan]

Try this:

Aggr(Rank(Count([DISTINCT OrderID]),4),Customer)>=10,Cutomer)

Vikas

[Luca1]

Thank you for your suggestion! If I use this expression, the expression editor complains about the expression with the error message from the screenshot below. I think there may be some mismatching bracket. 

 

[vikasmahajan]

Aggr(Rank(Count([DISTINCT OrderID],4),Customer)>=10,Cutomer)

[Luca1]

Hey, unfortunately your solution didn't work in my case. However, I have found a workaround to achieve my goal without using a button filter. Still, I would be interested in why this approach doesn't work. Potentially, there is no match found because the expression is not 100% accurate. 

[vikasmahajan]

Sorry Let me check at my end  will get back you tomorrow.

Vikas

[amantyagi1492]

I think here the thing you are trying to achieve should be done through "Select values matching search criteria". The other option you used does not work with the set expressions 

[tresesco]

Try the search string like:

'=Count(DISTINCT OrderID)>=10'