Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
daveatkins
Partner - Creator III
Partner - Creator III

how to allow user to select exclusions

I need to show a list of "exceptions" and allow users to check off the ones which should be excluded from the current selection. I want the user to be able to identify "outliers" so that the summary of data can be visualized without the outliers.

One way is to show a list box and have them select what should be included, but this is tedious and counter intuitive to users.

What is want is to design an interaction that is like "find and exclude."

I have done this with calculated fields--to provide a way to select null values for example--but I do not know the criteria for the outliers, so I cannot flag items with a "not outlier" field, etc.

6 Replies
vishsaggi
Champion III
Champion III

Can you give us some sample data and what you want to see in the listbox. Do you have any example data?

m_woolf
Master II
Master II

Can you have the user select the items to exclude. Then right-click and choose Select Excluded?

daveatkins
Partner - Creator III
Partner - Creator III
Author

that would require user "training" but it could be an option if there is no other way

Anonymous
Not applicable

You could do something like this.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can build your list of exceptions as a listbox or table and place this object in an alternate state.  Then reference that data in a set expression using either the "=-" or e() operators.  If you can provide a bit of sample data I can work up an example.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

m_woolf
Master II
Master II

You could eliminate the "Training" by putting a "Selected Excluded" button next to the List box.