topic Re: Removing items from an input box in App Development

Removing items from an input box

user08192 — Sat, 16 Nov 2024 05:21:21 GMT

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.

Re: Removing items from an input box

jwjackso — Mon, 08 Jul 2019 20:03:43 GMT

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

Re: Removing items from an input box

user08192 — Mon, 08 Jul 2019 20:10:28 GMT

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.

Re: Removing items from an input box

Rodrigo_Reis — Mon, 08 Jul 2019 20:48:53 GMT

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

Re: Removing items from an input box

user08192 — Mon, 08 Jul 2019 21:39:26 GMT

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?

Re: Removing items from an input box

Rodrigo_Reis — Tue, 09 Jul 2019 20:14:56 GMT

Newer versions of Sense have some "native" extensions.

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

Re: Removing items from an input box

user08192 — Thu, 11 Jul 2019 01:49:24 GMT

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.

Re: Removing items from an input box

jonathandienst — Thu, 11 Jul 2019 06:02:21 GMT

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