topic Sheet level access QlikView in QlikView

Sheet level access QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Sheet level access QlikView

Anil_Babu_Samineni — Thu, 19 Apr 2018 00:05:36 GMT

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

Re: Sheet level access QlikView

vishweshwarisun — Thu, 19 Apr 2018 06:28:36 GMT

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

];

Re: Sheet level access QlikView

vijetas42 — Thu, 19 Apr 2018 09:13:39 GMT

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

Re: Sheet level access QlikView

Anonymous — Mon, 23 Apr 2018 21:08:22 GMT

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