Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Section access on sheet level

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.

Tags (2)
1 Solution

Accepted Solutions
Support
Support

Re: Section access on sheet level

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


Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
7 Replies
MVP & Luminary
MVP & Luminary

Re: Section access on sheet level

Hi,

Check this link

Sheet level access


Sheet Level Access


Regards,

Jagan.

Support
Support

Re: Section access on sheet level

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


Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable

Re: Section access on sheet level

Thanks too much.

beck_bakytbek
Honored Contributor

Re: Section access on sheet level

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

Support
Support

Re: Re: Section access on sheet level

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

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
beck_bakytbek
Honored Contributor

Re: Re: Section access on sheet level

Hello Bill

Thanks a lot for your supporting Feedback

i will try it tommorow and will immediately report you

Thanks a lot

Beck

Not applicable

Re: Section access on sheet level

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?