Section Access at the Level of Sheets in QlikView

[nancy_sbeity]

Hello,

I am facing a problem with section access at the level of the sheets. Here is my tables:

SECTION Access;

LOAD ACCESS,

     NTNAME,

     CONTINENT,

     USER

FROM

...

SECTION Application;

LOAD USER,

     SH01,

     SH02,

     SH03,

     SH04,

     SH05

FROM

...

LOAD IDCountry,

     [Country Name],

     upper(Continent) AS CONTINENT

FROM

...

And i am giving a condition for each sheet : =SH01 for sheet1 etc..

This example isn't working with me. I am able to see all the sheets. Note that the fields SH01-SH05 are populated with 1 or 0.

But when I tried to use simple users not NTNAME:

section access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN,A,A

    USER,S,S

    USER,M,M

];

section application;

LOAD * INLINE [

    USERID, SH01,SH02,SH03,SH04,SH05

    A,1,1,0,0,1

    S,0,0,1,0,1

    M,1,0,0,0,0

];

It works!!

Is there any problem with NTNAME and sheets reduction or what is the problem?

[nancy_sbeity]

Kindly find my example

Thank you for all of you.

[swuehl]

Nancy, it can upload it only later this day.

Basically it was the script you posted above (as I understood you've used it).

Just to make sure:

The issue is the that data reduction on that field is not working at all, or are the records of the sheet access table limited to a single record and you still have problems with the sheet condition?

For example, if data reduction is applied correctly, but the sheet access table shows records where your above show condition fails, this would be a complete different thing we need to look into.

In short, when you log in to the QVW using NTNAME, how does your record(s) in the sheet access table look like?

[nancy_sbeity]

My Problem is the following:

I am able to do reduction based on fields per example, Nancy can see only AFRICA, Someone else is seeing EUROPE etc..

BUT I am not able to do reduction based on sheets. When I add a table that is populated by 0 or 1 for each sheet, for each user, ALL the users are seeing ALL the sheets.

[swuehl]

Ok, but the problem might be on a different area.

Can you please log in with an NTNAME user and post the sheet access table after reduction?

[jonathandienst]

I suspect that the problem has to do with the USER field not working the way you (and me) expected. So, scrap the USER field and use the NTNAME directly in the sheet lookup table:

LOAD USER NTNAME,

    SH01,

    SH02,

    SH03,

    SH04,

    SH05

FROM

Make sure that you include the domain qualifier in the NTNAME field in this table as well.

[qlikviewwizard]

Hi

Please check the below links. Hope this will help you.

Level Wise Security Access

Column level access using Section Access

Chart Level Access by user

QlikView Section Access Examples

[swuehl · Accepted solution]

This is a script that works for me using NTNAME (with my real credentials):

SECTION Access;

LOAD * INLINE [

ACCESS, NTNAME, CONTINENT, USER

ADMIN, XYZ\USER, EUROPE, A

];

SECTION Application;

LOAD * INLINE [

USER, SH01,  SH02,  SH03,  SH04,  SH05

A,1,0,1,1,0

B,0,1,1,0,1

];

LOAD IDCountry,

     [Country Name],

     upper(Continent) AS CONTINENT

INLINE [

IDCountry, Country Name, Continent

1, Germany, Europe

2, Great Britain, EUROPE

];

In settings - document properties - Opening, checked Initial data reduction option.

[nancy_sbeity]

I Tried the same example you gave me, and It works correctly!!

But when I load the data from EXCEL, it didn't.

I tried with another name other than user, same same.

[swuehl]

Works for me also loading from EXCEL, just copied the INLINE table 1:1 into Excel.

Hm, not sure why it's not working for you. This is only when using NTNAME / Excel or also USERID / Excel?

Have you enabled strict exclusion in opening settings? Maybe it's not a problem with NTNAME, but the USER field values (remember, all in UPPER case) to match with sheet access table?

[nancy_sbeity]

It seems I had some issues with the server I don't Know because I tried On another one and it works. Thank you all for your help I appreciate it.