topic Re: Section Access in QlikView

Section Access

Thu, 21 Sep 2017 03:42:31 GMT

Just upgraded to QlikView 12.

wanted to implement section access like admin can see only admin sheet and user can see only user sheet.

Used below inline section access table.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,FLAG

ADMIN, ABC, 123,1

USER, DEF, 678,0

];

Section Application;

For Admin sheet in sheet property show sheet condition is given FLAG=1 and in user sheet FLAG=0.

it is working fine in QlikView 12 desktop .

Initial data reduction on open in document property is checked with strict exclusion.

From access point it is working fine for ADMIN But for USER it is throwing error "Failed to open document ,you do not have access to this document".

Please help me on this .

Re: Section Access

qliksus — Thu, 21 Sep 2017 04:29:01 GMT

Do you have only one sheet in your document ? Did you typed the password correctly ?

Re: Section Access

tresB — Thu, 21 Sep 2017 04:49:58 GMT

Have you checked if the same is working in desktop?

Re: Section Access

Thu, 21 Sep 2017 07:40:17 GMT

Yes, it is working fine in desktop ,I have already mentioned in the query.

Document have 3 sheet , 2 for admin and 1 for user.

Re: Section Access

kaushiknsolanki — Thu, 21 Sep 2017 08:22:06 GMT

Hi,

Try dividing the section access into two different table like below.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ABC, 123

USER, DEF, 678

];

Section Application;

Load * inline [

USERID, FLAG

ABC,1

DEF,0

];

Now change your conditions to Sum(FLAG)=1 and Sum(FLAG) =0 and check if it works or not.

Regards,

Kaushik Solanki

Re: Section Access

Thu, 21 Sep 2017 11:10:47 GMT

No Kaushik, it is not working on access point.

Re: Section Access

Thu, 21 Sep 2017 11:11:19 GMT

It is working in desktop but not on access point.

Re: Section Access

pradosh_thakur — Thu, 21 Sep 2017 11:48:44 GMT

i may be wrong but under the reload tab of QMC there is a option for section access username and password. if you don't provide it the reload will perform under the username QDS is running. make sure you add that user as ADMIN or Provide the user name password of admin in the reload.

i was facing kind of same issue and this is how i solved it.

as it is section access make sure you have a backup.

regards

Pradosh