Users need to land on specific sheets depending on access

[nkosinde13]

Hi All

I have a model that uses section access and in it there are different tabs/sheets. Each sheet is activated by a button and depending on access, the buttons either activate the sheet or they don't (if access is set to  = 0 ). On user access list I'm using 1 or 0 to specify access to a sheet.

This is working perfectly except for users who don't have access to the first button which is Dashboard. What I want is for them to land only on the sheets they have access to, if they have access to more than 1 then it needs to land them on 1st sheet they have access to.

I tried adding this trigger on Document settings but it lands the users on the sheet I was active on instead of the first one they have access to.

  If(Sum({<[NT NAME] = {$(vOSUser)}>}Dashboard) =0,'SH11',GetActiveSheetId())

How do I modify this to work. Please help. 

Thanks

Matlotlo

[Brett_Bleess]

I believe the 'best' approach on this one is to use a 'base' sheet that has some how-to information etc. where you put the first button to which everyone will have access, but the trick will still be mapping the buttons to which the user should see etc.  The only thing of which I can think is to have all the buttons on that sheet, and only the ones to which they have access will show, but the issue is going to be the missing ones may not make that look very nice...  I am pretty sure you want a base sheet to which everyone will always have access, I am just not sure how you go from that point, but hopefully this may get you what you needed, and you can sort out the rest from there.  Look at some of our Demo apps, the Example apps that come with the installers, or https://demo.qlik.com might give you some ideas on an initial info sheet...

You can have a look on the Design Blog too, but I am not sure there is anything out there on this:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Rob W's Cookbook site might have some further ideas maybe:

https://qlikviewcookbook.com/

There is also a related/duplicate post on this: https://community.qlik.com/t5/QlikView-App-Development/Section-access-on-buttons-Landing-page/m-p/16...

Regards,
Brett