topic Re: Select alternative values in App Development

Select alternative values

sevvalk — Fri, 15 Nov 2024 21:16:39 GMT

Hi,

My data belongs to a company that produces to order. Each product ordered has a stock code. I want to easily filter some of these stock codes with a button. There are approximately 2000 product codes. I want to filter out the ones I do not want to appear among these product codes. The ones I don't want to be seen are approximately 50. Is there a button feature where I can select these 50 product codes and filter their alternatives? I don't want the person using the report to have to type these 50 product codes every time.

Thank you.

Re: Select alternative values

AshutoshBhumkar — Sun, 05 Nov 2023 13:55:47 GMT

Hi,

One of the ways would be to create a on time bookmark for those 50 Products.

Apply bookmark to select those 50 Products.

Use a Qliksense button to Select Excluded/Alternatives values. This will exclude 50 values from your bookmark and select remaining.

Thanks,

Ashutosh

Re: Select alternative values

cwolf — Sun, 05 Nov 2023 15:28:28 GMT

You can use "Compound Search" for a "Select Values in a Field" Action.

For example:

(*^(AA10|BB20|FHR5))

means: select all values except the values AA10, BB20 and FHR5.

Compound Search - demystified

Re: Select alternative values

barnabyd — Sun, 05 Nov 2023 20:44:07 GMT

G'day @sevvalk, I have two suggestions:

Create a bookmark - you need to make the selections the first time and then save them as a bookmark. After this, you can just use the bookmark. You can also make the bookmark public for other users to access.
A better solution (IMO) is to use a spreadsheet:
1. type the 50 codes into a speadsheet
2. in the load script, load the spreadsheet into a mapping table
3. use applymap() to create a new field in the main table, e.g. [Special Codes] = Yes/No
4. add the [Special Codes] as a filter on the page
5. if a new code needs to be added to the list then edit the spreadsheet and reload the app

I hope this helps. Cheers, Barnaby.

Re: Select alternative values

sevvalk — Mon, 06 Nov 2023 04:42:00 GMT

I solved it by first selecting the values I wanted and then giving the select alternatives command for that column.