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

[maxgro]

see here or post your qlik doc

Sheets Security with Section Access File

[beck_bakytbek]

Massimo Thanks a lot for your Feedback

Here my Qlikdoc. My Issue is: how can i do in Excell-Sheet a reduction to make visible the sheet within QlikView.

Thanks a lot

Beck

[maxgro]

we can't access your doc; section access?

[beck_bakytbek]

Massimo

Thanks, i used Qlik-License

My Issue is: How can i via Excel make visible some sheets within QlikView?

Thanks

Beck

[maxgro]

I can't open your qlik doc with section access

Only you can

Dwnl attachment

open, configure excel (your user) and save

open 0secacc.qvw

check Initial data reduction in menù, settings, document properties, opening

uncheck strict exclusion in menù.... (you'll check after some test)

reload, save and close qlik doc

reopen: depending on what you set in excel you have 1/2 sheets

[beck_bakytbek]

Massimo Thanks a lot

i will try to do it. if i have still any problem i will report you.

Do you have any examples to this issue?  because i can create the reduction within QlikView with Access Inline, but with issue : QlikView via Excell i dont have enough experience.

Thanks a lot any way

Beck

[beck_bakytbek]

Hallo Massimo,

Thanks a lot for your Feedback,

I have a question, regarding access section i used the NTNAME to make some sheets visible and some not( i used my ID as NTNAME). its working, but if i open my file, i can see all sheets, and if i create listbox and selekt my ID, then i see the reduction., how can i make, so if i open my file. i see my fieldsreduction without creating of listbox and selekting my ID.

Thanks a lot in advance

Beck

[Peter_Cammaert]

For all Section Access entries with role = ADMIN, QlikView Desktop will do that. You will get access to everything automatically, every time. This a special feature for developers, and it only works in QlikView Desktop. For other entries with Role=USER opening your document in QV Desktop, or for everybody (even Administrators) opening your document in the AccessPoint, reduction will operate as programmed.

Note that in order to completely close down your document so that people without anything left after data reduction will be thrown out, enable Strict Exclusion in Settings->Document Properties->Opening.

Best,

Peter

[beck_bakytbek]

Hello Peter

First of all thank for your supporting advice,

i tried to do this, and its working: if i (as Admin ) open my file, so i can see my sheets, but my colleagues (as User), they do not have access, they are not able open my file: access denied.

i enabled: strick exlusion, initial data reduction based on section access and prohibit binary load.

what did i wring?

do you have any idea?

thanks

Beck