Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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!
Hi,
Sorry, i using personal edition.
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...
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.
Here, I want search string expression for values
Settings -> Document Properties -> Triggers -> Variable Event Triggers -> EnterCategory -> OnInput -> Edit Actions(s) -> Search String:
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