Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Single select in field trigger for multiple fields

Hi All

I have a requirement as below.

Fields:

[Customer ID]

[Customer Num]

[Phone Number]

...., ... etc

I have an input box with variable which takes the search value from the user. Can I create a single variable event trigger to select in all the above fields instead of creating N number of 'Select in Field' trigger to search for the string entered by the user

Any suggestions will be much appeciated

Thanks in advance

Regards,

PM

7 Replies
Anil_Babu_Samineni

May be create "Composite Key" and use single field as Trigger

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kamal_sanguri
Specialist
Specialist

Nothing much you would need to do. Just add more actions and change the column name (Keep the variable same).

How will it work - so, If user enter something which is there in Col1 it would be selected and if user inputs any value which is not Col1. First trigger action will fail and Second action will happen.

See the snippet

Capture.PNG

Capture.PNG

Capture.PNG

Capture.PNG

Refer the attached for reference

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Hi Praveena,

had you considered using a Search Object?

Marcus

Anonymous
Not applicable
Author

Hi Kamal

Thank you for your response

I have 34 fields and do you think we need to add 34 'Select in Field' actions in the trigger.

Do you think we have a better solution for this

Regards,

PM

Anonymous
Not applicable
Author

Hi Marcus

Yes.. The requirement is to search multiple values of each field.. So 'Search Object' has a limitation here


Regards,

Praveena

kamal_sanguri
Specialist
Specialist

Yeah, I assumed that Praveena would have considered that.. before doing this  OR may be some specific requirement

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Hi Praveena,

ok fair point. A search object will allow you to search across your 34 fields, but the selection will be made in a single field.

Kamal's solution seems to be the way to go given the requirements you've stated - and yes you'd need to add 34 actions!

I would suggest that some simplification of your data model might pay off here. If you upload a copy of it I'm sure people can help.

Marcus