Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakkrish
Creator
Creator

Show Values by typing

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.

1 Solution

Accepted Solutions
deepakkrish
Creator
Creator
Author

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


Using an Input box to search a List Box

Thanks all

View solution in original post

11 Replies
nagarjuna_kotha
Partner
Partner

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

deepakkrish
Creator
Creator
Author

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

qlikdeez
Specialist
Specialist

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!

deepakkrish
Creator
Creator
Author

Hi,

Sorry, i using personal edition.

qlikdeez
Specialist
Specialist

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

deepakkrish
Creator
Creator
Author

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.

deepakkrish
Creator
Creator
Author

Ipbox.png

deepakkrish
Creator
Creator
Author

Here, I want search string expression for values

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

Peter_Cammaert

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