topic Re: Section access in QlikView

Section access

Mon, 21 Oct 2013 11:24:09 GMT

Hi All,

I have reduced the data based on Field value by using section access .I have given blank for admin to show all values for admin

Ex:

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, CUSTOMER

ADMIN, ADMIN, ADMIN,

USER, Emma, Emma, ABCInd

USER, Manisha, Manisha, XYZInd

];

Section Application;

Customer:

LOAD * Inline [

CUSTOMER, CODE

ABCInd, 1

XYZInd, 2

PQRInd, 5

];

But After distributing this in Access point, the admin cant able to open report it shows 'Failed to open' for admin.

Can anyone tell solution for this?

Re: Section access

Clever_Anjos — Mon, 21 Oct 2013 11:27:33 GMT

Don´t use blank, use *

and set

Star is *;
Section Access;
LOAD * Inline [
ACCESS, USERID, PASSWORD, CUSTOMER
ADMIN, ADMIN, ADMIN,
USER,  Emma, Emma, ABCInd
USER, Manisha, Manisha, XYZInd
];

Re: Section access

Gysbert_Wassenaar — Mon, 21 Oct 2013 12:05:18 GMT

All users accessing the document in the access point will get USER as ACCESS level, not ADMIN access. See this discussion for a solution: Section Access - View all data