topic Re: Select values matching criteria with a button in App Development

Select values matching criteria with a button

lucas3 — Thu, 16 Jun 2022 09:07:16 GMT

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

Re: Select values matching criteria with a button

Or — Thu, 16 Jun 2022 09:11:24 GMT

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

Re: Select values matching criteria with a button

lucas3 — Thu, 16 Jun 2022 09:16:45 GMT

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 ?

Re: Select values matching criteria with a button

Or — Thu, 16 Jun 2022 09:29:18 GMT

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

Re: Select values matching criteria with a button

lucas3 — Thu, 16 Jun 2022 13:14:20 GMT

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

Re: Select values matching criteria with a button

Or — Thu, 16 Jun 2022 13:23:02 GMT

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.