Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional Search Using Search Object

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:

untitled.bmp

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

untitled.bmp

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

1 Solution

Accepted Solutions
Not applicable
Author

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..

View solution in original post

3 Replies
Not applicable
Author

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

Not applicable
Author

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..

Anonymous
Not applicable
Author

Thanks Paul.. It worked like a wonder.