Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankhi
Creator
Creator

Sheet Level Access

Hi All,

I have a dashboard with two tabs. Now as per the access requirement, the 1st tab should be accessible to all whereas the 2nd tab only to 20 users.

 I have implemented a solution, where in I edited tab2 -- Sheet Properties--Conditional  and had written the below code. X and Y are user names and it is working fine. However the challenge with this solution is whenever a new user for tab2 needs to be added, everytime the code needs to be changed.

=if(match(upper(osuser()),
'DOMAIN\X',

DOMAIN\Y'
)=0, 0, 1)

Is there a way we can make it excel based, so that adding the usernames in the excel will allow the new user to get access in both the sheets and the application will not be required to update.

 

Many Thanks

Regards

Ankhi

1 Reply