topic Re: Testing Section Access in QlikView

Testing Section Access

Fri, 01 Feb 2013 11:31:38 GMT

HI,

Im trying to set up Section Access in my QV document. Is it possible to test if I have Data Reduction Working even if I am ADMIN?

In need the Data Reduction to work from the NTNAME of the user eg; DOMAIN\LoginID.

Any help appreciated

Fiorano

Re: Testing Section Access

Fri, 01 Feb 2013 12:20:20 GMT

Hi,

yes you can test Data Reduction even if your are Admin.

You should have something like this in your script :

SECTION ACCESS;

LOAD NTNAME,

ACCESS ,

FIELD_X,

FIELD_Y

FROM

[..\XLS\Section_Access.xlsx]

(ooxml, embedded labels, table is SA);

SECTION APPLICATION;

--Your Data

you have to Enable Section Access on document level:

Tick the option “Initial Data Reduction Based on Section Access” on “Settings” -> “Document Properties” -> “Opening”

Recommendations :

Backup your applications before implementing Section Access.

Work in multiple copies so that you can step back if you "lock" yourself out.

Use only UPPER CASE names for section access fields

Re: Testing Section Access

Fri, 01 Feb 2013 16:17:11 GMT

Hi, I have this working.

Is it possible to use 'Section Access' to show or hide Sheets depending on the user?

Thanks,

Fiorano

Re: Testing Section Access

Sat, 02 Feb 2013 22:05:52 GMT

Yes.

Try this :

SECTION ACCESS;

LOAD NTNAME,

ACCESS ,

FIELD_X,

ACCESS_SHEETX -- 1 or 0

FROM

[..\XLS\Section_Access.xlsx]

(ooxml, embedded labels, table is SA);

SECTION APPLICATION;

--Your Data

LOAD * INLINE [

ACCESS_SHEETX

];

On Conditional Show Sheet of sheet properties , add : only(ACCESS_SHEETX) = 1