topic Re: How to Use Search Object in QlikView

How to Use Search Object

Fri, 09 Sep 2011 09:46:55 GMT

Hi,

I am very new to Qlikview and need help from you guys..

I am tryig to create a data Dictionary in Qlikview and would like to use it like "google". As in, if we want to search any data..we would simply type in the data in the searchbox and all the corrosponding values of that data will appear in a table below. I have all the data in excel and have already loaded that in Qlikview.

Now I am lost what to do after this.

Please Help.!

Cheers..

Paul..

How to Use Search Object

Miguel_Angel_Baeyens — Fri, 09 Sep 2011 10:03:12 GMT

Paul,

Just go to any empty space in your sheet (or create a new sheet), right click and select "New Sheet Object", "Search Object". The object properties dialog will show up, make sure Search in "All Fields" radio button is selected and click OK.

There you are the search object that will return you all fields and all values matching what you type (as you type it!).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to Use Search Object

Fri, 09 Sep 2011 10:13:23 GMT

Thanks Miguel for your comments..

I want all the search results shown in a table..

Can You help me how to do it ?

Thanks

Paul

Re: How to Use Search Object

Fri, 09 Sep 2011 10:15:22 GMT

Thanks Miguel for your comments..

I want all the search results shown in a table..

Can You help me how to do it ?

Thanks

Paul

How to Use Search Object

Miguel_Angel_Baeyens — Fri, 09 Sep 2011 10:31:28 GMT

Hi Paul,

It doesn't work that way. What do you actually have and where do you want to get? Take a look in the Reference Manual at the Concat() function, but I'm not sure what do you want to show.

Regards,

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: How to Use Search Object

Thu, 15 Sep 2011 06:26:40 GMT

Thanks Miguel for the guidence...

I got what i was looking for...!! 🙂

How to Use Search Object

Wed, 07 Mar 2012 18:31:23 GMT

Hi,

i'm also looking to have exactly what u have skd for..but dnt know how to do it....cud u plz guide me..how have u actually did it.......stuck wid this from the past 2 days.......bt no help

Regards

Re: How to Use Search Object

Mon, 12 Mar 2012 07:38:42 GMT

Hi,

Now Create a straight table from the Chart option ( Right click on blank field > new sheet object > Chart > straight table) and place the table just below the search field.

Type in your keywords in the searchbox and you can see the result in the table

Hope this will work for you.

Thanks

Re: How to Use Search Object

Mon, 12 Mar 2012 08:00:43 GMT

Thanks it worked.........

Regards