topic Re: Section access on buttons. Landing page in QlikView

Section access on buttons. Landing page

nkosinde13 — Sat, 16 Nov 2024 19:13:16 GMT

Hi All

I have a model that has section access applied. Only difference is that it does not hide sheets that users are restricted from as the model uses buttons to navigate through different sheets.

So instead users can still see the buttons they're restricted from, but they are grayed out with no actions i.e. they cannot click it to activate the sheet or perform any action.

The problem that I have is, the first button on the model is "Dashboard"and some users don't have access to it. Currently when the model is open all users land into Dashboard even if they are restricted. So how do I ensure that those users land only on the button(s) they have access to?

Thanks

Re: Section access on buttons. Landing page

Claudiu_Anghelescu — Fri, 31 Jan 2020 13:42:19 GMT

You can create a file where you can put USERID and SHEET as columns

Then you load the data from Excel file and put the condition in (Layout - Show -Conditional) on sheet/object like this:

=upper(OSUser())= USERID and SHEET='Dashboard'

Re: Section access on buttons. Landing page

Brett_Bleess — Mon, 24 Feb 2020 15:36:37 GMT

Regards,
Brett

Re: Section access on buttons. Landing page

nkosinde13 — Tue, 25 Feb 2020 08:44:24 GMT

Good day All

Thank you so much for all the responses. We managed to find a workaround, so in the user access list I created a field: DocumentID which is basically the sheet object ID for each buttons in the model. So for each user I put in the sheet ID for the first button they have access to, forcing them to land on that and this is because we did not want to hide the buttons which they do not have access to, we instead grayed them out.

Then under Document triggers, on Activate Sheet I used this expression:

=Only({<[NT NAME] = {$(vOSUser)}>}DocumentID)

See the attached document for an example of how the access looks on the model as well as example of user list.