topic Re: Search in a input box in QlikView

Search in a input box

Fri, 03 Jul 2015 12:01:22 GMT

Hi all!

I'm new to qlikview and help would be much appreciated. I have created a input box and have used the constraints tab to pre-define values in drop down and used the string: Concat(DISTINCT Service, '; ') to list the values from the column. My problem is that the dropdown list returns around 1000 diffrent values to chose between (as it should). My question is if theres a way to ad a seach function in the input box to retrieve the already listed values (for example, if the value i want to retreve starts with: A5000xxxx, all the values that starts with A5000 will pop up in the dropdown)?.

Best regards

Hampus

Re: Search in a input box

stigchel — Fri, 03 Jul 2015 12:06:27 GMT

Use a search object and use wildcard search as search mode

Re: Search in a input box

marcus_sommer — Fri, 03 Jul 2015 12:09:17 GMT

AFAIK you couldn't search within the inputbox-listing but you could limit and/or sort these list, maybe in this way:

concat({< YourField = p(YourField) >} distinct Service, ';', YourSortField)

- Marcus

Re: Search in a input box

Fri, 03 Jul 2015 12:23:44 GMT

the input box defines variables that are unique to charts and lists on the same tab and can't be sorted using search objects, but thanks for your suggestion!

Re: Search in a input box

Fri, 03 Jul 2015 12:24:15 GMT

thanks! i'll try this

Re: Search in a input box

Fri, 03 Jul 2015 12:37:06 GMT

AH, this actually works! If i use the search object to sort out the value i want then go to the input box and use the drop-down menu only the searched values are listed.

Thank you!!

Re: Search in a input box

stigchel — Fri, 03 Jul 2015 12:41:02 GMT

You're welcome. You could also just use the search box, it will give you a dropdown where you can select as well. You could then use a Field trigger to set a variable

Re: Search in a input box

Fri, 03 Jul 2015 12:55:20 GMT

Ah, cool, ill give it a shot!:) Thanks!