Is there any bug online with sheet restriction access?

[mikael_cleuziou]

Hello,

I use restriction sheet access with my section application. (Using conditional sum(SH01)>=1 in sheet properties)

My USER X can see only sheet 1;2;3;5 not number 4.

When I am using Qlikview desktop with X identifiants, it works perfectly

When I am opening my document by the access point in fullweb. X can't see the sheet number 4.

But if X click on something (filter or a sheet) all the hidden sheets appeared!

I think, I must have an option activated or desactivated. Do you have an idea?

Best regards,

MC

[chematos]

I think you need to review your section access

Please, copy an example of the security to see how you are using the section access with sheet conditions

regards

[mikael_cleuziou]

Hello,

Thanks for your answer.

Here you can find my script :

SECTION Access;
// ****************** Chargement des profils utilisateurs ****************** \\
SACCESS:
// Récupération des utilisateurs techniques :
LOAD DISTINCT
     UPPER(ACCESS) AS ACCESS,
     UPPER(NTNAME) AS NTNAME,
     UPPER(USERID) AS USERID,
     UPPER(PASSWORD) AS PASSWORD,
     UPPER(PRENOM) AS PRENOM,
     UPPER(NOM) AS NOM 
FROM [$(vPathDataFiles1)BGE - Section Access.xlsx](ooxml, embedded labels, table is BGE_TECHNICAL_USER);

Concatenate
//Récupération des utilisateurs BGE :
LOAD DISTINCT
     UPPER(ACCESS) AS ACCESS,
     UPPER(NTNAME) AS NTNAME,
     UPPER(USERID) AS USERID,
     UPPER(PASSWORD) AS PASSWORD,
     UPPER(PRENOM) AS PRENOM,
     UPPER(NOM) AS NOM, 
     UPPER(USERGROUP)    AS USERGROUP // Le nom du champ faisant le pont entre la section Access et la section Application

     // UPPER(OMITGROUP)AS OMITGROUP
FROM [$(vPathDataFiles1)BGE - Section Access.xlsx](ooxml, embedded labels, table is TABLEAUX_DE_BORD);

SECTION Application;
Star is *;
//// ****************** Chargement des droits d'acces SHEET ****************** \\
// Aller dans la propriété de la feuille et conditionner l'affichage ie =sum(SH04)>=1

SHEET:
LOAD DISTINCT
     UPPER(USERGROUP)      as USERGROUP,             
     SH12,
     SH04,
     SH10,
     SH11,
     SH06,
   SH15,
   SH16,
   SH17,
   SH18,
   SH19,
   SH20,
   SH21,
   SH22,
   SH23,
   SH24,
   SH25,
   SH26,
   SH27,
   SH30
FROM [$(vPathDataFiles1)BGE - Section Access.xlsx](ooxml, embedded labels, table is TABLEAUX_DE_BORD_SHEETACCES);

Here is an extract of my excel file.

USERGROUP	SH12	SH04	SH10	SH11	SH28	SH06	SH15	SH16	SH17	SH18	SH19	SH20	SH21	SH22	SH23	SH24	SH25	SH26	SH27	SH29	SH30
BG75	1	1	1	1	0	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0
BG77	1	1	1	1	0	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0
BG91	1	1	1	1	0	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0

Then I use conditional show in each sheet : =sum(SH01)>=1

It works nice with Qlikview desktop but not by accesspoint.

Thanks for any idea!

Best,

Mikael

[mikael_cleuziou]

Hello,

I don't find a solution to this problem.

Anyone have an idea?

Best regards,

[Carlos_Reyes]

You may find this document useful:

Sheets Security with Section Access