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

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

Thu, 14 Feb 2013 15:52:06 GMT

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

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

alexandros17 — Thu, 14 Feb 2013 16:26:21 GMT

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

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

khadeer — Thu, 14 Feb 2013 16:34:29 GMT

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

PFA. And let me know if u want more.

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

Thu, 14 Feb 2013 17:13:34 GMT

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

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

Thu, 16 May 2013 04:59:46 GMT

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

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

khadeer — Thu, 16 May 2013 16:55:48 GMT

Hi,

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

Regards,

Khadeer

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

Tue, 16 Jul 2013 15:48:19 GMT

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