topic Re: Select values matching search criteria with set expressions in App Development

Select values matching search criteria with set expressions

Luca1 — Sat, 16 Nov 2024 16:52:24 GMT

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-values-in-a/td-p/1843387

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!

Re: Select values matching search criteria with set expressions

vikasmahajan — Thu, 30 Dec 2021 12:36:41 GMT

Try this:

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

Vikas

Re: Select values matching search criteria with set expressions

Luca1 — Thu, 30 Dec 2021 12:57:31 GMT

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.

Re: Select values matching search criteria with set expressions

vikasmahajan — Thu, 30 Dec 2021 13:27:31 GMT

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

Re: Select values matching search criteria with set expressions

Luca1 — Thu, 30 Dec 2021 14:04:17 GMT

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.

Re: Select values matching search criteria with set expressions

vikasmahajan — Thu, 30 Dec 2021 14:42:24 GMT

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

Vikas

Re: Select values matching search criteria with set expressions

amantyagi1492 — Wed, 20 Apr 2022 06:30:36 GMT

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

Re: Select values matching search criteria with set expressions

tresB — Wed, 20 Apr 2022 06:54:54 GMT

Try the search string like:

'=Count(DISTINCT OrderID)>=10'