topic Re: Question to Search Object in QlikView

Question to Search Object

qlikconsultant — Tue, 02 Dec 2014 11:13:25 GMT

I have a product key (only nummbers) the key is divided into two columns. The user must be able to search for a key.

Right now I use it two search objects. I try to avoid merging the 2 columns in the script.

Is there a way that after entering the part of the key the cursor jumps to the second search object?

I tried the tabulator key but it seems not to be working.

Re: Question to Search Object

mato32188 — Tue, 02 Dec 2014 11:25:29 GMT

Hi Markus,

probably not, but I am not sure. It is most common to use a list box of Key1 and make expression of Key2, to have those Keys row by row. But this is not the answer to your question. Just an advice.

Re: Question to Search Object

Gysbert_Wassenaar — Tue, 02 Dec 2014 11:29:56 GMT

Not as far as I know. There are no actions/events to move the cursor to an object.

You could use two list boxes and show the second one only when a selection has been made in the first one and also hide the first list box (or disable it by showing a semi-transparent text box on top of it). You can use the Conditional option on the Layout tab to enter an expression that evaluates the number of selections in the first field; something like =if(getselectedcount(KeyPart1)=1,1,0)

Re: Question to Search Object

qlikconsultant — Tue, 02 Dec 2014 12:25:39 GMT

I had the same idea and tried it now.

Unfortunately, the solution does not work in my case. My data is too large and thus brings QlikView to a standstill.

Re: Question to Search Object

qlikconsultant — Tue, 02 Dec 2014 12:32:20 GMT

With this solution, the user would have to also use the mouse to click the search icon in the list box. So no real benefit for the user. Is it possible to customize the list box so only the search option is available?

Re: Question to Search Object

Gysbert_Wassenaar — Tue, 02 Dec 2014 12:48:43 GMT

Not as far as I know. That's what you'd use a Search Object for.