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

Activate trigger on sheet one time

Hi Guys,

I have a sales sheet which has an trigger that's activating an bookmark when selecting the sheet.

But this needs to be doen only once. When leaving the sheet to other sheets and switch back to the sales sheet, the trigger with the bookmark should not go off.

Can this be done? Preferly without macros.

Thanks

Robbie

5 Replies
Chanty4u
MVP
MVP

Hi,

Did you tried OnLeave  trigger ?  on sheet properties?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Why dont you use the On Open Trigger at application level.

Meaning, when you open the application the trigger will be fired.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

Hi Chanty,

But what needs to be define? Deactivate bookmark?

Rob

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

I do think bookmark makes same selections.

In this case on leaving the sheet you just need to Clear All selections.

Try like below:

Screenshot_1.jpg

jonathandienst
Partner - Champion III
Partner - Champion III

There's no easy way to tell the system to fire the trigger on first selection and not on subsequent ones, so you will have to manage state through variables and a combination of triggers. Although you might be able to get something like that working its likely to complicated and possibly unreliable.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein