topic Re: Listbox: searching for values returned by expression in QlikView

Listbox: searching for values returned by expression

sibrulotte — Fri, 06 Nov 2015 23:26:36 GMT

Hi,

I'd like to have the user type in a project name or a project number in the header of a listbox of project names that has numbers as expression.

Example: type "236" or "Licence" and you'll end up at the same result.

I don't want the user to have to click on the "more search options" or whatever in the upper right corner.

I have a slew of other listboxes to accomplish the same.

Is there a way to accomplish this using only the visualisation tools,

or do I have to create fields in the script to get the two components in the same field and us that in my listbox?

swuehl — Fri, 06 Nov 2015 23:37:35 GMT

The text search in project field should be standard and well known, right?

You can use an advanced search (start the search string with 😃 to search the expression results.

For example, if your expression is something like

=Sum(Hours)

Just use as search string

=Sum(Hours) = 236

Drawback: Your users may need to know the expressions and search syntax

sibrulotte — Fri, 06 Nov 2015 23:40:33 GMT

Definite drawback, I can't even write my expression like a boss without copy paste:

=only({1}[Extra comptable 3])