Removing items from an input box

[user08192]

My client has a number of projects with project numbers. She has memorized these numbers and wants to exclude certain ones from our Qlik Sense app. Her preference is to type the numbers into a box (input field) and have those projects be removed from the visualization.

Is there any way to do this? I've attached a sample QVF which just has some basic data, a bar chart, and a text field that serves as a placeholder.

Thank you in advance for any suggestions. 

[jwjackso]

Could she use the filter pane and in the search box type (10010,39989,51000) and then select excluded?

[user08192]

I might have to make her try that if I can’t come up with an alternative method. She wants it to be directly on the sheet, which is what I’m attempting to do, but if nothing solves it she’ll need to settle for using the filter pane.

[Rodrigo_Reis]

Create a variable ("vDesconsider" for example) and use the expression:
sum ({<[Project #] - = {$ (= vDisconsider)}>} Amount).

Important: Values ​​must be separated by commas in the input field

[user08192]

Thank you for the suggestion. I think this may work, but I’m struggling to find an input box extension that will work with this variable. Any thoughts?

[Rodrigo_Reis]

Newer versions of Sense have some "native" extensions.

Look for the "Variable Input" that is in the custom objects  -->  "Qlik Dashboard Bundle"

[user08192]

Thanks for the help, but I think I need to give up. I still can’t get it to do what I need it to do.  But I learned a new tool, so that’s a plus.

[jonathandienst]

How about this:

• Create an 'excluded project' field like this:

LOAD Distinct ProjectCode as Project_Exclude
Resident ....;

• Now add an exclude condition to the chart expressions:

Sum({<ProjectCode = E(Project_Exclude)>} Amount)

or this:

If(GetSelectedCount(Project_Exclude),
  Sum({<ProjectCode = E(Project_Exclude)>} Amount),
  Sum(Amount)
)

Now your user can select one or more projects from and see the results excluding the selected projects.

A bit of work, but a better user experience...