topic Re: Default Sheet Display in QlikView

Default Sheet Display

Mon, 13 Jan 2014 09:36:17 GMT

Good Day QlikCommunity,

I would like to know if it is possible for a default Sheet to be loaded every time a user accesses a dashboard as currently on the portal it remains on the last selection that was made by the last user.

I have a Welcome tab which i would like to be displayed everytime a user accesses the Dashboard.

Regards,

Sanjeev

Re: Default Sheet Display

datanibbler — Mon, 13 Jan 2014 09:39:34 GMT

Hi,

easy: You can add triggers on several levels - among others, on Document_level. Here, you can set QlikView to open a specific sheet when the app is opened.

=> On sheet-level, you can set some default selections.

Do experiment and test with those triggers a bit, though - some of them don't work in the Ajax client, for ex.

HTH

Best regards,

DataNibbler

Re: Default Sheet Display

Mon, 13 Jan 2014 09:40:29 GMT

Hi Sanjeev,

Yes it can be done. You can add a trigger/action "Onopen" of the document. For this:

1. In menu bar, go to Settings--Document Settings--Triggers tab.

2. In Document Event Triggers, select Onopen, then Add Action.

3. Action Type : Layout

Action : Activate Sheet

and give the Sheet ID of desired sheet. (In your case Welcome tab sheet ID).

4. Save, close and re open the file.

Hope this helps!

Re: Default Sheet Display

Mon, 13 Jan 2014 10:49:59 GMT

Thank You Shyamal

It works like a bomb!