Section access on buttons. Landing page

[nkosinde13]

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

[Claudiu_Anghelescu]

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'

[Brett_Bleess]

See related post: https://community.qlik.com/t5/New-to-QlikView/Users-need-to-land-on-specific-sheets-depending-on-acc...

Regards,
Brett

[nkosinde13 · Accepted solution]

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.