Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
edouard_chandav
Contributor II
Contributor II

Double/triple/field search

Hello,

I have a "Search field" looking into "nom_tiers_orga" and 'nom_tiers_contractant"

(1) When I search "Fluo" and click on Fluo as "nom_tiers_orga" I would like Fluo as "nom_tiers_contractant"  to be also selected.

I think this can be achieved thanks to a documment trigger?

(2) I need to keep the 2 results even if they are "contradictory" when Fluo is selected for "nom_tiers_orga" and 'nom_tiers_contractant"

I might need to use an 'Union" ?

   

Can you help please?

Affairenom_tiers_organom_tiers_contractant
PARISORANGEFLUO
NEUILLYFLUOVERT
1 Reply
ogautier62
Specialist II
Specialist II

Hi,

OR condition on two fields of same table will be not simple

may be concatenate in load the two fields and then search in concatenate field

regards