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?

[swuehl]

Could you give some sample lines of your first two tables? What are the values of USER in both tables?

[awhitfield]

Hi Nancy,

check out the attached posting, it should help point you in the right direction:

https://community.qlik.com/message/599893#599893

HTH - Andy

[nancy_sbeity]

Hello,

I already saw this thread and it works without DOMAIN USERS as if I use users and passwords.

But when I use NTNAME I can't see the same solution,

example of my tables: ADMIN , DOMAIN\NANCY, ASIA, NANCY

                                   USER,DOMAIN\JIJI, AFRICA, JIJI

and for the second table:

NANCY,1,0,1,0.....

JIJI,1,0,0,0...

Any help?

[jonathandienst]

Did you check the values of SH01 - SH05 when you open the domain users version of the document?

[awhitfield]

Would of thought the NTNAME in the second table needed to be in the DOMAIN\NTNAME format too!

DOMAIN\NANCY etc...

Andy

[nancy_sbeity]

I am trying these two examples on the same sheets, on the same application. so if the value of the sheet is wrong it won't work on the other example.

Andrew I tried this too but it won't work.

Note that the reduction on the field continent is working!!

[swuehl]

Seems to work for me using NTNAME at my side.

Could you please upload a complete script with INLINE tables that is NOT working at your side?

[Digvijay_Singh]

Check if this can help Switching from USERID to NTNAME in Section Access

[nancy_sbeity]

Dear Swuehl,

Can you please send me your example , i am not able to attach my application.