Select values matching criteria with a button

[lucas3]

Hi,

I have a field named ' Account ' that contains values of the following shape: "xxxxxxxx - Account name": 8 digits followed by the name of the account.

By clicking on the button, I would like to select only the accounts for which the digits pattern is as such: 451xxx10 or 451xxx20 and then whatever the name is

How to achieve that ? Plus, do you have a document that explains expressions to type inside a button ( *, ^, ?, |, &, etc...)

Thank you

[Or]

Seems like it would be e.g. 451???10*

https://community.qlik.com/t5/Qlik-Design-Blog/Qlik-Sense-Cheat-Sheet-version-2-0/ba-p/1667455

[lucas3]

Thank you for your reply and for the document, that is exactly what I was looking for

I tried your answer already but it did not work... I entered it as in the picture, is that wrong ?

[Or · Accepted solution]

It probably needs to be e.g. ='451???10*'

[lucas3]

I selected the wrong "action", I picked "Select values in a field" instead of "Select values matching search criteria". It works perfectly well, thanks

I have another question though, how now if I want to select all Accounts except the ones that start with a 45 (eg 45*) and except the ones that contain a 3 in 2nd position and a 7 in 5th position (eg ?3????7?). What formula should I type ?

Thank you very much

[Or · Accepted solution]

I am not aware of any way to do this directly. You may be able to achieve the same result by using an action to select the undesirable values, and then a second action to selected the alternative (or excluded) values.