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

Announcements
Join us in Bucharest on Sept 18th 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.