topic Conditional Search Using Search Object in QlikView

Conditional Search Using Search Object

Anonymous — Mon, 19 Sep 2011 08:31:37 GMT

Hi,

I am developing a template in QV 9 where I need to impliment a search object, which will search 3 different fields based upon selection.

To explain more Below is an Example:

The above table has 3 columns and they have common item in them. Now I have to provide check box in QV

I have to provide a method by which user can select which field he/she wants to search by selecting the check boxes. It can be a single selection or a multiple selection. Can anyone provide me a solution WITHOUT USING MACRO please. Attached is the sample

Thanks In advance

Anurag

Re: Conditional Search Using Search Object

Mon, 19 Sep 2011 10:10:58 GMT

Hi Anurag,

take a look at the attached version of your example. I created a Variable vColSwitch and three search-objects.

Your User can decide which field should be the searchfield via the value of the variable and the conditional showing of one of these three search-objects (properties --> layout tab --> check "conditional show" and edit the condition).

HtH

Roland

Re: Conditional Search Using Search Object

Mon, 19 Sep 2011 10:46:48 GMT

Hi Anurag,

Expression in Search object Properties > General Tab > List of Fields > Put the expression as " Getfieldselections( ) " function...

Please use the below attached and see if that helps..!

Cheers..

Paul..

Conditional Search Using Search Object

Anonymous — Mon, 19 Sep 2011 10:47:54 GMT

Thanks Paul.. It worked like a wonder.