Access Section

[beck_bakytbek]

Hi Colleagues

I have one question to issue: Access Section

How can i create via Excell-Sheet to make visible some Sheets within QlikView?

i saw one example and tried to use, but i didnt have success:

Sript looks as follows:

star is *;

SECTION Access;
Directory;
LOAD ACCESS,
NTNAME,
SAUSER
FROM
[Book1 - Kopie.xlsx]
(ooxml, embedded labels, table is Tabelle1);

SECTION Application;

DocSecurity:
LOAD
SAUSER,
TABACCESS.SHEET1,
TABACCESS.SHEET2,
FIELDACCESS.DIVISIONFILTER as Division
FROM
[Book1 - Kopie.xlsx]
(ooxml, embedded labels, table is Tabelle1);

FACTTABEL:
LOAD * INLINE [
Division, Date, Product, ProductSku, Qty, Amt
North, 01/10/2010, Widget 1, BBCD-1234, 52, 220.0097
South, 01/10/2010, Widget 1, BBCD-1234, 52, 220.0097
South, 01/11/2010, Widget 2, FFGH-1234, 10, 120.0000
];

Do any of you happen to have an idea?

Thanks a lot

[Peter_Cammaert]

Either they do not feature in your SA table (specify full domainname\accountname entries) or their data reduction results in nothing. If QlikView has no data left after data reduction, a user will be denied access.

[beck_bakytbek]

Hi Peter,

this is my scripting:

Section

Access;
Directory;
LOAD ACCESS,
NTNAME,
SAUSER,
SHEET1,
SHEET2,
SHEET3,
SHEET4
FROM
[Access Section NTNAME.xlsx]
(ooxml, embedded labels, table is Tabelle1);

SECTION Application;

Directory;
LOAD ACCESS,
NTNAME,
SAUSER,
SHEET1,
SHEET2,
SHEET3,
SHEET4
FROM
[Access Section NTNAME.xlsx]
(ooxml, embedded labels, table is Tabelle1);

What do you mean with; "If QlikView has no data left after data reduction", my issue is, that just some sheet are available for my colleagues.

what did i wrong? if you want, i can send my file

Thanks a lot

Beck