topic Re: Can Search Box double up as Button? in QlikView

Can Search Box double up as Button?

Sat, 25 Jan 2014 17:03:13 GMT

Hi, I was looking at putting in a new feature in my dashboards. The idea is to collate all chart ids in my dashboard (all custom names) into a table and use the Search box to help quickly find the table I need. Currently I need to use a Button to show/hide the table searched for. I was wondering if it will be possible to have the table restored/maximized/shown immediately after pressing Enter key after search.

Let's say I have two tables:

comics: (objectId - Comics)

[Comics

Calvin And Hobbes

Peanuts

Garfield];

fruits: (objectId - Fruits)

[Fruits

Apple

Mango];

Search_Table: (used in Search box)

[search

Comics

Fruits];

I need the search box to also open the table when I search the ObjectId. I don't want to use a Button/TextBox action. Is it possible?

Re: Can Search Box double up as Button?

whiteline — Sat, 25 Jan 2014 18:27:52 GMT

Hi.

After you pressed enter the selection was made in the 'search' field.

So you can use a simple Conditional Show (Properties->Layout) expression for your charts.

Something like =search='Comics' and =search='Fruits'

Re: Can Search Box double up as Button?

Colin-Albert — Sat, 25 Jan 2014 19:46:20 GMT

Actions are not available from the Search object. Actions are available on buttons, text objects, gauges and lines.

Re: Re: Can Search Box double up as Button?

whiteline — Tue, 28 Jan 2014 08:43:16 GMT

Sample

Re: Can Search Box double up as Button?

Thu, 30 Jan 2014 07:02:49 GMT

Hi. This was really helpful. Didn't know about the search syntax. Is there a way I can force it to minimize/maximize the table. I can make use show/hide if maximize doesn't work though.

Re: Can Search Box double up as Button?

Thu, 30 Jan 2014 07:10:01 GMT

PFA, Something like this..

Thank you

Vardhan

Re: Can Search Box double up as Button?

Thu, 30 Jan 2014 07:32:59 GMT

Hi Vardhan, I have tried macros and felt it was not scalable. I currently have to edit the macro everytime I add a new table or remove an existing one. Hence wanted to know if there was an alternative.

Re: Re: Can Search Box double up as Button?

Thu, 30 Jan 2014 08:18:01 GMT

check this, without using macro.

Thank you

Vardhan

Re: Can Search Box double up as Button?

whiteline — Thu, 30 Jan 2014 14:29:40 GMT

Hi.

No, it's just conditional show feature.

Though, you can have more than one object that appears/disappears when the user select something in the search field.

Re: Can Search Box double up as Button?

Sat, 01 Feb 2014 09:27:59 GMT

Thanks Vardhan. This uses the same method as suggested by Whiteline. Looks like minimization is not possible. Not sure if conditional show/hide uses lesser resources compared to minimization.

Re: Can Search Box double up as Button?

sudeepkm — Sat, 01 Feb 2014 12:17:07 GMT

I'm not sure if you have already used an Input box.

You can store the objects IDs in a variable.

Use that variable in an input box.

Go to the layout of the Object and use conditional show: e.g. Variable1 = 'Furits' //(this is for the object Fruits)

This may look similar to what has been suggested by other members. I've attached the QVW for your reference.

Re: Can Search Box double up as Button?

Mon, 03 Feb 2014 08:22:17 GMT

Thanks Sudeep, but conditional show is not what I am looking for. It's rather conditional minimize/maximize. Will there be a performance difference between conditional show and minimizing?