topic Re: Section access on sheet level in QlikView

Section access on sheet level

Tue, 02 Sep 2014 15:31:36 GMT

Hi all,

I've made a test for section access on sheet level("Data Team" can see all sheets, the users in "IB Team" only can see SH10 and SH11).

But It doesn't work as I expect. I don't know what's wrong in my qvw file.

Please give me some advice.

Thanks and best reagrds,

Keep going.

Re: Section access on sheet level

jagan — Tue, 02 Sep 2014 15:40:23 GMT

Hi,

Check this link

Sheet level access

Sheet Level Access

Regards,

Jagan.

Re: Section access on sheet level

Bill_Britt — Tue, 02 Sep 2014 15:40:24 GMT

Hi,

Section Access would be something like this.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,PROFILE

admin, college, college,COLLEGE

user, physics, physics,PHYSICS

user, chemistry, chemistry,CHEMISTRY

user, maths, maths,MATHS

];

Section Application;

Profile:

LOAD * INLINE [

PROFILE, SH01, SH02, SH03, SH04

PHYSICS, 1, 1, 0, 0

CHEMISTRY, 1, 0, 0, 1

MATHS, 1, 0, 1, 0

COLLEGE, 1, 1, 1, 1

Then your show sheet condition would be like

SH02<>0

Re: Section access on sheet level

Wed, 03 Sep 2014 03:10:35 GMT

Thanks too much.

Re: Section access on sheet level

beck_bakytbek — Tue, 28 Oct 2014 19:41:46 GMT

Hello Going Keep

I have one question to issue: Access Section

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

i saw one exmple 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/2009, Widget 1, ABCD-1234, 52, 220.0097
South, 01/10/2009, Widget 1, ABCD-1234, 52, 220.0097
South, 01/11/2009, Widget 2, EFGH-1234, 10, 120.0000
];

Thanks a lot

Beck

Re: Re: Section access on sheet level

Bill_Britt — Tue, 28 Oct 2014 20:47:21 GMT

Hi,

Here is a QVW and Excel Sheet from my example.

Section Access would be something like this.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,PROFILE

admin, college, college,COLLEGE

user, physics, physics,PHYSICS

user, chemistry, chemistry,CHEMISTRY

user, maths, maths,MATHS

];

Section Application;

Profile:

LOAD * INLINE [

PROFILE, SH01, SH02, SH03, SH04

PHYSICS, 1, 1, 0, 0

CHEMISTRY, 1, 0, 0, 1

MATHS, 1, 0, 1, 0

COLLEGE, 1, 1, 1, 1

Then your show sheet condition would be like

SH02<>0

Bill

Re: Re: Section access on sheet level

beck_bakytbek — Tue, 28 Oct 2014 21:22:21 GMT

Hello Bill

Thanks a lot for your supporting Feedback

i will try it tommorow and will immediately report you

Thanks a lot

Beck

Re: Section access on sheet level

Tue, 28 Oct 2014 23:29:20 GMT

Hello Bill!

I have just one doubt. All of this is to give access and permissions on the document level right?

So, if I have DMS security enabled, when a user, for example 'Admin1' from group 'Executives' opens the document, where is the link between the user that comes from DMS and the user that is stored on the xls?

Do I have to specify it somewhere?

Re: Section access on sheet level

DBIT — Tue, 20 Jun 2023 20:39:19 GMT

Really needed to see this. I couldn't visualise it when it was explained to me. Thanks.