Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nivedita2590
New Contributor II

"sheet event trigger" not functioning properly. Any alternatives ?

Hi All,

The "sheet event trigger" extension is not working in Qlik Sense as expected. The values get set for a particular sheet only when we close and reopen the app.

The motive is to set some values in a particular field on opening any sheet, so that data get filtered as per required resources on that particular sheet.


Is there any one aware of this limitation of "sheet event trigger" ? Are there any other ways to achieve this functionality ?


Regards,

Shilpa




Tags (1)
1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: "sheet event trigger" not functioning properly. Any alternatives ?

What I would do, is using the GitHub - stefanwalther/sense-navigation: Sheet Navigation + Actions for Qlik Sense. extension (which, by the way, is a certified extension)

This one is really stable and offer good options (I'm always using it):

To resume what I do,

I create buttons in each sheet (for navigation);

each button will be used as a navigation button to open a new sheet + setting up an action (in your/my case, applying bookmarks):

Here's a scenario:

Create an Introduction sheet (which contains introductions, KPIs etc..) and buttons to each sheet :

The button:

Navigation behaviour: go to specific sheet

action: apply bookmark (your bookmark would be the fields you want to select)

Capture.PNG

This way, when you open your dashboard, you'll first open your introduction page, then click on a button to go to another sheet:

It will transfer you to the desired sheet and apply your bookmark

Example: I click on rapport: it will tranfer me to the report sheet and apply bookmark(see the filter pane)

Capture.PNG

How to create your bookmark action:

If you wanna have Year 2017 selected by default for example and timeframe = annuel (as in the image below)

Create a Bookmark and name it 2017 for exp then call it.

How to do so?

Make your selections:

Capture.PNG

Then make a bookmark of your current selection as follow:

Capture.PNG

Now in the extension button,

You add an action: apply bookmark and select your bookmark.

Capture.PNG

With that, when you'll navigate on a specific sheet when clicking in the button, it will also activate your bookmark and thus you'll find the year 2017 and timeframe annuel selected.

Hope this helps?

2 Replies
omarbensalem
Esteemed Contributor

Re: "sheet event trigger" not functioning properly. Any alternatives ?

What I would do, is using the GitHub - stefanwalther/sense-navigation: Sheet Navigation + Actions for Qlik Sense. extension (which, by the way, is a certified extension)

This one is really stable and offer good options (I'm always using it):

To resume what I do,

I create buttons in each sheet (for navigation);

each button will be used as a navigation button to open a new sheet + setting up an action (in your/my case, applying bookmarks):

Here's a scenario:

Create an Introduction sheet (which contains introductions, KPIs etc..) and buttons to each sheet :

The button:

Navigation behaviour: go to specific sheet

action: apply bookmark (your bookmark would be the fields you want to select)

Capture.PNG

This way, when you open your dashboard, you'll first open your introduction page, then click on a button to go to another sheet:

It will transfer you to the desired sheet and apply your bookmark

Example: I click on rapport: it will tranfer me to the report sheet and apply bookmark(see the filter pane)

Capture.PNG

How to create your bookmark action:

If you wanna have Year 2017 selected by default for example and timeframe = annuel (as in the image below)

Create a Bookmark and name it 2017 for exp then call it.

How to do so?

Make your selections:

Capture.PNG

Then make a bookmark of your current selection as follow:

Capture.PNG

Now in the extension button,

You add an action: apply bookmark and select your bookmark.

Capture.PNG

With that, when you'll navigate on a specific sheet when clicking in the button, it will also activate your bookmark and thus you'll find the year 2017 and timeframe annuel selected.

Hope this helps?

pablolabbe
Valued Contributor II

Re: "sheet event trigger" not functioning properly. Any alternatives ?

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.