2 Replies Latest reply: Dec 31, 2017 1:16 PM by Pablo Labbe RSS

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

    nivedita2590 nivedita2590

      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




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

          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?

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

            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.