Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Tenuki
Contributor III
Contributor III

Create a button to exclude one category

I would to create a button with an action that exclue a value from a field.

And I don't find an action that match this behaviour.

Is there a simple way to do this or I have to use "Select matching values" ?

Many thanks for your help.

Labels (2)
1 Solution

Accepted Solutions
Andrea_Bertazzo
Support
Support

@Tenuki I tried this.
I created a button with two actions.
The first action is a "Select Values in a Field" and you use it to select the value that you want to exclude.
The second action is a "Select Excluded" on the same field.

So when you click on the button, first the value is selected, then the second action exclude it and takes all the other.

I recommend you to test this option carefully, in order to be sure that the two actions are always performed in the correct order by the button. 
It works on my environment.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂

View solution in original post

2 Replies
Andrea_Bertazzo
Support
Support

@Tenuki I tried this.
I created a button with two actions.
The first action is a "Select Values in a Field" and you use it to select the value that you want to exclude.
The second action is a "Select Excluded" on the same field.

So when you click on the button, first the value is selected, then the second action exclude it and takes all the other.

I recommend you to test this option carefully, in order to be sure that the two actions are always performed in the correct order by the button. 
It works on my environment.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
Tenuki
Contributor III
Contributor III
Author

Hello, 

I didn't see we could add another action.

It work on my case, thanks for your help and advise.