Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a dashbord that contains 3 tabs. I need to hide access to hide one of the tab for a specific user. Any idea how to do it?
Thanks
You can use the conditional show property of the sheet in combination with the OSUser() function.
Hi,
you can do something like this:
Let's say you have a sheet with ID SH03 that must be hidden for USER2.
SECTION ACCESS;
LOAD * INLINE [
USERID,PASSWORD, ACCESS
ADMIN,ADMIN, ADMIN
USER1,PASS1,USER
USER2,PASS2,USER
];
SECTION APPLICATION;
LOAD * INLINE [
USERID,SHEETID
USER1,SH01
USER1,SH02
USER1,SH03
USER2,SH01
USER2,SH02
ADMIN,SH01
ADMIN,SH02
ADMIN,SH03
];
Then in your sheet properties, add the following conditional expression:
=SUM(IF(SHEETID='SH03',1,0))>=1
Please let me know if this helps.
Kind regards,
Thanks Santiago for your reply.
In my case, users access the qlikview acees point by using login/pass of their sessions. How to change SECTION ACCESS part?
Wiem,
If you dont have section access in your document, you need to follow what piet hein mentioned. But if you have more number of users, i recommend you need to create section access for sheet level access mentioned by Santiago.
-Siva