topic Re: Single select in field trigger for multiple fields in QlikView

Single select in field trigger for multiple fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Single select in field trigger for multiple fields

Anil_Babu_Samineni — Mon, 19 Jun 2017 07:28:30 GMT

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

Re: Single select in field trigger for multiple fields

kamal_sanguri — Mon, 19 Jun 2017 08:19:39 GMT

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

Refer the attached for reference

Re: Single select in field trigger for multiple fields

marcus_malinow — Mon, 19 Jun 2017 08:28:18 GMT

Hi Praveena,

had you considered using a Search Object?

Marcus

Re: Single select in field trigger for multiple fields

Anonymous — Mon, 19 Jun 2017 08:30:05 GMT

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,

Re: Single select in field trigger for multiple fields

Anonymous — Mon, 19 Jun 2017 08:31:54 GMT

Hi Marcus

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

Regards,

Praveena

Re: Single select in field trigger for multiple fields

kamal_sanguri — Mon, 19 Jun 2017 08:33:37 GMT

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

Re: Single select in field trigger for multiple fields

marcus_malinow — Mon, 19 Jun 2017 09:36:52 GMT

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