topic Re: Show Values by typing in QlikView

Show Values by typing

deepakkrish — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have one list box(Quarter) and four values Q1,Q2,Q3,Q4. My requirement is i have to show the values after typing it i need to

press ENTER button which will show me the result. suggest me one good object alternate of search box.

Re: Show Values by typing

nagarjuna_kotha — Thu, 24 Nov 2016 11:40:05 GMT

In that case , if u don't want to see initial values then use multi box , it provides you as drill down view.if u click on the down arrow drop down will come and u can make selections as u want.

i hop this might helps you.

-Nagarjun

Re: Show Values by typing

deepakkrish — Thu, 24 Nov 2016 11:49:02 GMT

Hi Nagarjun

No i want to make end user easy and this is my requirement. i think inputbox will suited for that,

can u explain me how to use inputbox

Re: Show Values by typing

Anonymous — Thu, 24 Nov 2016 12:29:35 GMT

Hi,

See sample app attached using input box to search and press enter to filter list box

It uses a variable called vSearchString

Hope this helps!

Re: Show Values by typing

deepakkrish — Thu, 24 Nov 2016 12:57:45 GMT

Hi,

Sorry, i using personal edition.

Re: Show Values by typing

Anonymous — Thu, 24 Nov 2016 13:22:15 GMT

Create Variable in script

Let vSearchString = '';

Then reload to create the variable

Create an inputbox and add the variable vSearchString

Create a listbox with your field you want to search

Listbox properties> General> Field > drop down and select expression right at the bottom

enter the expression:

=if(WildMatch(YourField,'*$(vSearchString)*'),YourField)

Under General> Title > enter:

=if(count(if(wildmatch(YourField,'*$(vSearchString)*'),YourField))=0,'No Product found!','Search Results:')

Layout> Show> Check Conditional & enter the below expression in the inputbox

=len(vSearchString) <> 0

You should be able to search a string, hit enter and filter the listbox.

* The listbox will only be visible when the input box is not empty...

Re: Show Values by typing

deepakkrish — Thu, 24 Nov 2016 14:34:12 GMT

That's OK. but my requirement is same like search string from field through input box

If i type any value an input box, it would be reflect in pivot table.

Re: Show Values by typing

deepakkrish — Thu, 24 Nov 2016 14:44:20 GMT

Re: Show Values by typing

deepakkrish — Thu, 24 Nov 2016 16:18:17 GMT

Here, I want search string expression for values

Settings -> Document Properties -> Triggers -> Variable Event Triggers -> EnterCategory -> OnInput -> Edit Actions(s) -> Search String:

Re: Show Values by typing

Peter_Cammaert — Thu, 24 Nov 2016 16:48:14 GMT

I don't think QlikView offers a feature like that (doing calculations while you type dimension values, sort of Google-like).

Me thinks that a feature like that can be very expensive with respect to CPU utilization when using it on large data sets. That would result in the opposite effect for your end-users: making the document slow and lagging = annoying to use.

Peter

Re: Show Values by typing

deepakkrish — Thu, 24 Nov 2016 16:57:21 GMT

How do I use a trigger to search for some values and exclude others?

Qlikview certainly offering the feature. See the discussion.

Re: Show Values by typing

deepakkrish — Thu, 24 Nov 2016 17:14:35 GMT

I got a answer. It easy to implement with a macro:

Using an Input box to search a List Box

Thanks all