topic Re: In Document Event Triggers, OnOpen-->Select on Field selection in QlikView

In Document Event Triggers, OnOpen-->Select on Field selection

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

Hello, Everyone,

I have a hard time finding a solution to the following challenge:

I have a list box called "Buyers' and has 100 values, and I have another field called "Favorite Buyer"(from different source) has 5 values.

When I open the page it will display only the "Favorite Buyer" values in "Buyers" list box as default. later if I want to clear the default values then "Buyers" list box will display all the 100 values.

I have set the trigger like:

Sheet Properties==>Triggers==>OnActiveSheet==>Select in Field==> Field is "Buyers" and Search String is "=[Favorite Buyer]"

but its not working. please help.

Regards

Jhanaarthanan

Re: In Document Event Triggers, OnOpen-->Select on Field selection

sunny_talwar — Fri, 25 May 2018 17:25:44 GMT

Would you be able to share a sample to look at this?

Re: In Document Event Triggers, OnOpen-->Select on Field selection

vishsaggi — Fri, 25 May 2018 17:36:29 GMT

May be try this in your search string?

Select in Field

Buyers

Search String

= '(' &Concat(DISTINCT [Favorite Buyer],'|') & ')'

Re: In Document Event Triggers, OnOpen-->Select on Field selection

jcampbell474 — Fri, 25 May 2018 20:33:40 GMT

I haven't had the best luck using On Open > Select in Field triggers. A workaround that I usually resort to is entering a search string into the listbox (using the search function), then saving the result as a bookmark. Create an On Open > Apply Bookmark trigger and see it works for you.

Here's one thread (of many) for reference: Bookmark on Open

HTH,

Jason

Re: In Document Event Triggers, OnOpen-->Select on Field selection

a0693051 — Tue, 29 May 2018 12:09:56 GMT

Hi Viswarath,

Thanks for your help and now resolve the issue with your inputs.

I just alter your Search String with below, because in [Favorite Buyer] column values has space in-between and first character is single quote.

Search String

='(' & Concat(DISTINCT chr(34) & [Favorite Buyer] & chr(34),'|') & ')'

Thanks a lot.

Regards

Jhanaarthanan