topic Re: hidden Tab in QlikView

hidden Tab

master_student — Mon, 15 Aug 2016 12:57:44 GMT

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

Re: hidden Tab

stigchel — Mon, 15 Aug 2016 13:01:44 GMT

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

Re: hidden Tab

santiago_respane — Mon, 15 Aug 2016 13:08:58 GMT

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,

Re: hidden Tab

master_student — Mon, 15 Aug 2016 13:40:53 GMT

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?

Re: hidden Tab

Siva_Sankar — Tue, 16 Aug 2016 02:33:29 GMT

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