How To Set Up Section Access to reduce access for specific sheets in Document

[#1]

Hi There

I wanted to know how to setup section access in QlikView so that the user has access to certain tabs as specified in the section access script.

For example I have a QlikView document which has a high-level executive dashboard on one tab and four other tabs with further analysis of the high-level dashboard. I want executives with a username and password to only have access to a tab in the document which points to the executive dashboard and the team who do the analysis to have access to the tabs which hold the further analysis. I do not want the analysis team to have access to the executive dashboard and I do not want the executive to have access to the analysis tabs in the document.

I have already done section access reducing data based on fields by specifying the fields in the section access script and this works.

Just like data reduction, is there a way to do this to reduce tabs in QlikView?

Thanks

[alexandros17]

I've solved the problem using a condition based on a control of users in show always/conditional property of the sheet

Hope it helps

[khadeer]

Yes u can do by using section access in sheet level.

PFA. And let me know if u want more.

[#4]

Hi QV Learner

Thank you for the reply. This is quite useful.

I tried to apply it to my example but the sheet access did not work. The data field reduction is working but the tab access reduction is not.

Here is my code taken directly from my script.

SECTION ACCESS;

LOAD ACCESS,

     USERID,

     PASSWORD,

     COMPANY

FROM

[..\Desktop\SECTIONACCESS.xlsx]

(ooxml, embedded labels, table is Sheet1);

SECTION APPLICATION;

LOAD USERID,

     SH01,

     SH02,

     SH03,

     SH04,

     SH05,

     SH06

FROM

[..\Desktop\SECTIONACCESS.xlsx]

(ooxml, embedded labels, table is Sheet2);

Section Application;

LOAD Platform_ID,

     upper(Company) AS COMPANY ,

     UPPER(Platform) AS PLATFORM

FROM

GameData.xlsx

(ooxml, embedded labels, table is Platforms);

As you can see I have two section application tables. One is to load the tab access spreadsheet taken from your example and the other one is for linking the field 'COMPANY' so that the data reduction can happen.

The data reduction is fine and the usernames and corresponding passwords are working too. It's just the sheet access not working.

Thanks

[#5]

Hi Khadeer,

I too tried the logic you had given in my current dashboard. But it is not working as expected. It is asking for user with prompt but after that it is showing all the tabs.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, GROUP

    ADMIN, ADMIN1, GROUP1

    USER, USER1, GROUP2

    USER, USER2, GROUP3

];

Section Application;

LOAD * INLINE [

    GROUP, Sheets, flag

    GROUP1,SH01, 1

    GROUP1,SH02, 0

    GROUP2,SH01, 0

    GROUP2,SH02, 1

    GROUP3,SH01, 1

    GROUP3,SH02, 1

];

This is the condition for tab visibility.

=sum(If(Sheets='SH01',flag))

Could you help me in sorting this out ?

Thanks in advance

Regards

Ravi

[khadeer]

Hi,

Just write condition tab in sheet properties as sum(SH01)>=1

Regards,

Khadeer

[#7]

I solved this just by adding a Text Object to my window that displayed the time, using this expression: =now(1)

I didnt have to change any other properties on the model