Sheet level access QlikView

[Anonymous]

Hi, i´m trying to apply Sheet Level access for users into my document.

I´ve created an excel file named "sheetlevel" with this configuration :

USERID	HOJA1	HOJA2
USER1	1	1
USER2	0	1

On my test I wanna allow USER1 to see all sheets and USER2 to see only sheet named as "HOJA2". But when I log with any of two users, I can see both sheets.

I´ve already set the "condition" son Sheet Properties tab.

If you have any Wiki related with the configuration of Sheet level access, it will be welcome.

Could you help me? I don´t know what I am doing wrong.

[Anil_Babu_Samineni]

There is no password in excel, But it is asking Password when i open document? Can you bell on that

[vishweshwarisun]

hi,

try this

Section Access;

LOAD * INLINE [

    ACCESS, USERID

    ADMIN, USER1

    USER, USER2

];

Section Application;

SheetAccessMatrix:

LOAD *

inline[

USERID,SH02,SH04

USER1,1,0

USER2,0,1

];

[vijetas42]

Have you checked strict exclusion option from document properties->opening->check option Initial data reduction based on section access->strict exclusion

[Anonymous]

Thanks!! That was my problem! Now it works!!!