Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

hidden Tab

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

4 Replies
stigchel
Partner - Master
Partner - Master

You can use the conditional show property of the sheet in combination with the OSUser() function.

CondShowSheetUser.png

santiago_respane
Specialist
Specialist

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,

master_student
Creator III
Creator III
Author

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?

Siva_Sankar
Master II
Master II

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