topic Re: Section access help please. in QlikView

Section access help please.

Wed, 20 Jan 2016 02:43:30 GMT

I have a dashboard with 3 tabs.For one user based on the email ID i have to give access to just 1 SHEET(SH83 ) .My section access script is as below.

Section Access;

LOAD * INLINE [

ACCESS, UserID

User, abc@abc.com

];

Section Application;

SheetAccessMatrix:

LOAD

UserID,

SH69,

SH83,

SH95,

FROM

[client\Security.xlsx]

(ooxml, embedded labels, table is Sheet1);

and my excel file is as below:

UserID SH69 SH83 SH95

abc@abc.com 0 1 0

User abc only can see sh83.But when I login as that user I see all 3 tabs.What am I missing here ? I also have initial data reduction and strict exclusion option checked in documnet properties.

Thanks for all the help.

Re: Section access help please.

jagan — Wed, 20 Jan 2016 02:58:06 GMT

HI,

Check this link

Sheet Level Security

Refer Sheet Properties -> Show Sheet -> Conditonal option for conditionally hiding the sheet.

Hope it helps you.

Regards,

Jagan.

Re: Section access help please.

Chanty4u — Wed, 20 Jan 2016 05:12:46 GMT

hi,

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

chk dis

Re: Section access help please.

Peter_Cammaert — Wed, 20 Jan 2016 08:04:26 GMT

First, convert all Section Access field values to upper case. Then load your SheetAccessMatrix table with UserID formatted like:

...upper(UserID) AS UserID, ...

Link field values in Section Access are always converted to upper case. If strict exclusion isn't enabled, you will end up with all data being available to everyone.

You didn't forget to enable "Data Reduction based on Section Access" in Settings->Document Properties->Opening, did you?

Peter

Re: Section access help please.

Wed, 20 Jan 2016 21:43:09 GMT

Thank you Jagan.I followed the above document while I started working on section access.Not sure ,what is missing though.

Re: Section access help please.

Wed, 20 Jan 2016 21:44:41 GMT

Thank you Peter.I tried doing uppercase and it is still showing all the tabs when I log in with the email ID assignd to section access.Also,I have both the data reduction and Strict exclusion options checked.Not sure what is missing.

Re: Section access help please.

swuehl — Wed, 20 Jan 2016 21:52:08 GMT

I assume it's rather a problem of your sheet object conditional show expression than the section access.

Could you post the list box values of fields SH69, SH83, SH95 and the conditional expressions you are using?