Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sevvalk
Creator
Creator

Select alternative values

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.

 

Labels (2)
4 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

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.

AshutoshBhumkar_2-1699192129305.png

 

Thanks,

Ashutosh

 

 

cwolf
Creator III
Creator III

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
Partner - Creator III
Partner - Creator III

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.

Barnaby Dunn
BI Consultant
sevvalk
Creator
Creator
Author

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