Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

section access at sheet level

I implemented section access on tables. But I have a doubt in implementing it on sheets. The question is as follows:

Suppose I have 10 sheets in a QlikView application. How can you give access to user to view sheets 3,6, and 8 only ?

Can anybody please help me with implementing this.

9 Replies
oknotsen
Master III
Master III

Add a PROFILE column to your section access table.

Add a separate table in which you link the PROFILE column to a bunch of flag fields (like for example Sheet3, Sheet6 and Sheet8) that you set to either 0 or 1, depending on if someone is allowed access to the sheets or not.

Add a "conditional show" to the sheets in which you add an expression like "Sheet3 = 1".

May you live in interesting times!
Not applicable
Author

Thanks Enrique!!

Could you please provide a link where I can view the text in ENGLISH and understand the content.

Thanks,

Laxmaiah Chowdary

Anonymous
Not applicable
Author

I had the similar requirement and I did something like this...

I had 3 sheets in my case and created flags for each one of them Flag1,Flag2 and Flag3.

My Section access table would look something like this

SECTION Access;

LOAD

ACCESS,

NTNAME,

BU,

ROLE     

FROM [..\QVD\users.qvd](qvd);

And my section application part would looks something like this..

SHEET_ACCESS:

LOAD * INLINE [

ROLE,Flag1,Flag2,Flag3

R1,1,1,1

R2,1,1,1

R3,0,1,0

R4,1,1,1

];

Hope this helps you to build your section application table.

Regards,

Laxmi

krishna20
Specialist II
Specialist II

Hi,

Please find the below script as well as attached Excel. Hope it helps.

Section Access;

Star is *;

LOAD ACCESS,

    NTNAME,

    COMP_CODE,

    DEPT_CODE,

    SH01,

    SH02,

    SH03,

    SH04,

    SH05

FROM

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

LOAD //ACCESS,

    NTNAME,

    //COMP_CODE,

    //DEPT_CODE,

    SH01,

    SH02,

    SH03,

    SH04,

    SH05

FROM

(ooxml, embedded labels, table is Sheet1);

Not applicable
Author

Thanks Laxmi Kuber and Krishna20 for answers.

I got an understanding from other posts that Conditional option at Setttings -> sheet properties -> General needs to be enabled.

https://community.qlik.com/docs/DOC-4435

https://community.qlik.com/docs/DOC-6078

Can you please suggest that what is to be written in Conditional option in order make it work

Thanks in advance.

Anonymous
Not applicable
Author

Hi,

In the above Section Application table example I gave...

SHEET_ACCESS:

LOAD * INLINE [

ROLE,Flag1,Flag2,Flag3

R1,1,1,1

R2,1,1,1

R3,0,1,0

R4,1,1,1

];

Lets assume Flag1,Flag2 and Flag3 are flags for 3 Sheets Sheet1,Sheet2 and Sheet3 respectively.

Then you can write if(Flag1=1,0) in Conditional option under Settings->Sheet Properties->General for Sheet1.

This will enable that Sheet1 whenever Flag1=1 else the sheet will not be enabled for that particular user i.e when Flag1=0.

Hope this helps.

Regards,

Laxmi

qlikviewwizard
Master II
Master II

Hi Check this thread - Section Access