Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

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

May be try this in your search string?

Select in Field

Buyers

Search String

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

View solution in original post

4 Replies
Highlighted

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

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

Highlighted
Champion III
Champion III

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

May be try this in your search string?

Select in Field

Buyers

Search String

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

View solution in original post

Highlighted
Creator III
Creator III

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

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

Highlighted
Contributor III
Contributor III

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

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