Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Trigger performance help

Hey guys

I'm having performance issues with all of my triggers

in my model each time I move from one sheet to another I have around 10  triggers, select in field that need to be selected

any ideas on how I can improve the performance?

Thanks

J

6 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

1. Don't use triggers.

2. Try to use bookmarks

3. Explains what you're trying to achieve. Why are you using triggers.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

i tried the bookmarks and it was much worse.

the requirement is that each time a user enters a sheet there are a few selections required

is there a difference on adding a trigger on sheet or on document, performance wise?

or maybe a macro would have better results ?

Roop
Specialist
Specialist

Can you not use "Set Clear State" as your default state that is set when "Clear" is pressed. You would then just need 1 trigger on opening the sheet.

This would have the additional benefit of ensuring that the default state was selected when pressing "Clear" as well as making system quicker.

The "Set Clear State" is under the "Clear" drop down ....

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

the requirement is that each time a user enters a sheet there are a few selections required

That sounds like one bookmark per sheet and a Replace Bookmark action for the OnLeave Sheet trigger and an Activate Bookmark action for the OnActivate Sheet trigger. That should not impact performance significantly. If you do experience performance degradation you should analyse your document to find bottlenecks. You can use the Document Analyzer for this purpose.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

when I remove the triggers the performance is great

the proble are the triggers is there any other way to select in field besides bookmarks and triggers ??

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The other way is to let the users decide which selections they like to use.

Your Select in Field actions can be costly, depending on how you construct your search strings. Bookmarks should be less costly. Well, that depends too. Perhaps you'll store complicated search strings in the bookmarks too.


talk is cheap, supply exceeds demand