Select alternative values

[sevvalk]

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.

[AshutoshBhumkar]

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

[cwolf]

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 

[barnabyd]

G'day @sevvalk, I have two suggestions:

1. 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.
2. 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.

[sevvalk]

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