Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

bonacuse
New Contributor II

Limit List Box Searches to Simple Matches

Is there any way to limit the search string in a list box to simple matches? In other words, can QlikView prevent a user from entering an expression as a search string? In the example below, a user could enter this expression to see the ingredients for XYZ (intellectual property issue) in the list box preview before the enter key is pressed. Once the enter key is pressed, there are triggers or conditional expressions that could be used to reset the selections or to hide the charts or list boxes when the data set displayed is small enough for the users to discern the formula. Waiting for the enter key to be pressed, however, is too late as the users would have already seen the formula ingredients.

=count({<FormulaCode={'XYZ'}>} IngredientCode)>0

We know that could use island tables, but we're hoping that there is a better solution. Another solution would be to trap user input, but I couldn't find the ability to do this in the QlikView documentation.

5 Replies
MVP
MVP

Re: Limit List Box Searches to Simple Matches

You could consider disabling search in caption tab of list box properties, then use an input box with button to allow filtered search for that field.

edit: Doesn't seem to work, only search icon is disabled

edit2:

You can disable the search bar completely by removing the caption on caption tab.

Then you can use an input box to search values and prevent user from using an advanced search.

This approach won't show the 'live' preview when typing the search anyway (neither for the allowed searches).

Have a look at attached sample.

itberatung24
New Contributor III

Re: Limit List Box Searches to Simple Matches

... but you can still use the search capabilities using "right mouse click"

Or did I miss something?

MVP
MVP

Re: Limit List Box Searches to Simple Matches

Oh, yes, you are right. Don't know how to disable this.

For your specific request, maybe a data island is indeed the most simple solution (well, you won't get the associative experience with white / grey for other selections easily then).

I tried using a straight table chart, (dimension and expression your field name, then enable search on the expression and hide the dimension), but this search is not really a feature as good as a list box, and you won't get the associative colouring here, neither.

Not applicable

Re: Limit List Box Searches to Simple Matches

Hi, Tom.

Actually, you could use a special symbol "|" in a search string. For example (253|4568|8986) in a search of list box will give exact matches for values 253, 4568 and 8986. So you will not get 2531, 2532 ... 2539 as  search results (in case this field has such values).

bonacuse
New Contributor II

Re: Limit List Box Searches to Simple Matches

Hi Philipp,

Thanks, but the idea is to prevent users from entering a complex search string like the one below. We still want to let the users do wild card searches, but not complex ones.

=count({<FormulaCode={'XYZ'}>} IngredientCode)>0

Community Browser