- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- « Previous Replies
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Could you give some sample lines of your first two tables? What are the values of USER in both tables?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you check the values of SH01 - SH05 when you open the domain users version of the document?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would of thought the NTNAME in the second table needed to be in the DOMAIN\NTNAME format too!
DOMAIN\NANCY etc...
Andy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check if this can help Switching from USERID to NTNAME in Section Access
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Swuehl,
Can you please send me your example , i am not able to attach my application.
- « Previous Replies
- Next Replies »