Section access help please.

[#1]

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.

[jagan]

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.

[Chanty4u]

hi,

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

chk dis

[Peter_Cammaert]

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

[#5]

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

[#6]

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.

[swuehl]

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?