How can we restrict sheet level access if different users needs to access different sheets? Also We are using a web version of Qliksense and OSUSER us not showing the ID with Domain\user ID. Its showing as Directory ; ID and providing the same with Mixmatch function is not working
@@Qlikkie Actually when I am using "not mixmatch" Iam able to access the sheet, so it is working the other way round. Ideally I should not have access to the sheet if used not mixmatch. In my project, I have 4 sheets for which some people should only access two out of 4 and similarly few should access remaining two. But there are also few users who should be able to access all 4. What could be done in this case ?
@@rushalibhand4944 For this scenario, you need to have an excel file in the backend with columns: sheet name & username then vUsers Definition =CHR(39)&CONCAT(DISTINCT {} USERID,CHR(39)&','&CHR(39))&CHR(39) While accessing vUsers pass a parameter with name of the sheet i.e. vUsers('SheetName') So you show condition expression would look like MixMatch(OSUSER(),$(vUsers('SheetName'))) Hope this helps, If still any question comment them below
@@Qlikkie Hi, Thanks for the explanation above. I have implemented the same but unfortunately it is not yielding the result as expected. I have created an excel in which I have provided the sheetname adjacent to username but with mixmatch, I am unable to see basically any sheet. In my excel, I have repeated usernames for different sheet access.
@@rushalibhand4944 i too tried this.. and m finding the same result.. if i use not mixmatch iam able to see the sheet and without not its working as expected.
Thanks the video was really helpful to understand the concept
Glad that it helped
Thanks :)
How can we restrict sheet level access if different users needs to access different sheets? Also We are using a web version of Qliksense and OSUSER us not showing the ID with Domain\user ID. Its showing as Directory ; ID and providing the same with Mixmatch function is not working
Hi Muthu,
Which version of QS your using?
Hi, the above variable vUsers gives error in expression. Can you please check and revert back ?
Hi, what error are you facing?
Also did you create the in line table as shown in 02:10 ?
Make sure column name is same
@@Qlikkie Actually when I am using "not mixmatch" Iam able to access the sheet, so it is working the other way round. Ideally I should not have access to the sheet if used not mixmatch. In my project, I have 4 sheets for which some people should only access two out of 4 and similarly few should access remaining two. But there are also few users who should be able to access all 4. What could be done in this case ?
@@rushalibhand4944
For this scenario, you need to have an excel file in the backend
with columns: sheet name & username
then vUsers Definition
=CHR(39)&CONCAT(DISTINCT {} USERID,CHR(39)&','&CHR(39))&CHR(39)
While accessing vUsers pass a parameter with name of the sheet i.e. vUsers('SheetName')
So you show condition expression would look like
MixMatch(OSUSER(),$(vUsers('SheetName')))
Hope this helps, If still any question comment them below
@@Qlikkie Hi, Thanks for the explanation above. I have implemented the same but unfortunately it is not yielding the result as expected. I have created an excel in which I have provided the sheetname adjacent to username but with mixmatch, I am unable to see basically any sheet. In my excel, I have repeated usernames for different sheet access.
@@rushalibhand4944 i too tried this.. and m finding the same result.. if i use not mixmatch iam able to see the sheet and without not its working as expected.
Why go to add char(39)
It is for single quotes i.e. '
To wrap the userID value in single quotes as it a string