Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nancy_sbeity
Partner - Contributor III
Partner - Contributor III

Section Access at the Level of Sheets in QlikView

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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

20 Replies
swuehl
MVP
MVP

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

awhitfield
Partner - Champion
Partner - Champion

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
awhitfield
Partner - Champion
Partner - Champion

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

DOMAIN\NANCY etc...

Andy

nancy_sbeity
Partner - Contributor III
Partner - Contributor III
Author

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
MVP
MVP

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

nancy_sbeity
Partner - Contributor III
Partner - Contributor III
Author

Dear Swuehl,

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