topic Re: section access at sheet level in QlikView

section access at sheet level

Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: section access at sheet level

oknotsen — Sat, 10 Oct 2015 17:57:30 GMT

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".

Re: section access at sheet level

ecolomer — Sun, 11 Oct 2015 19:12:09 GMT

see this:

¿Alguien sabe cómo restringirle a ciertos usuarios el acceso a algunas hojas?

Re: section access at sheet level

Mon, 12 Oct 2015 10:55:38 GMT

Thanks Enrique!!

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

Thanks,

Laxmaiah Chowdary

Re: section access at sheet level

ecolomer — Mon, 12 Oct 2015 13:02:17 GMT

See this:

Section Access: Desktop vs Server

Chart Level Access

How to Distribute Dashboard and Implement Section Access

Re: section access at sheet level

Anonymous — Thu, 15 Oct 2015 05:51:04 GMT

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

Re: section access at sheet level

krishna20 — Thu, 15 Oct 2015 08:58:50 GMT

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);

Re: section access at sheet level

Mon, 19 Oct 2015 05:44:03 GMT

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.

Re: section access at sheet level

Anonymous — Tue, 20 Oct 2015 04:30:56 GMT

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

Re: section access at sheet level

qlikviewwizard — Tue, 20 Oct 2015 04:55:53 GMT

Hi Check this thread - Section Access