Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

6 Replies

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

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_sparks
Valued Contributor

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

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

PFA. And let me know if u want more.

Not applicable

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

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

Not applicable

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

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_sparks
Valued Contributor

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

Hi,

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

Regards,

Khadeer

Not applicable

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

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

Community Browser