Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

user08192
New Contributor

Removing items from an input box

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.

Test-image.png

 

Thank you in advance for any suggestions. 

Labels (2)
7 Replies
jwjackso
Valued Contributor

Re: Removing items from an input box

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

user08192
New Contributor

Re: Removing items from an input box

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
New Contributor II

Re: Removing items from an input box

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
New Contributor

Re: Removing items from an input box

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
New Contributor II

Re: Removing items from an input box

Newer versions of Sense have some "native" extensions.

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

user08192
New Contributor

Re: Removing items from an input box

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.

Highlighted
MVP
MVP

Re: Removing items from an input box

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein