Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mikael_cleuziou
New Contributor III

Is there any bug online with sheet restriction access?

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

4 Replies
chematos
Valued Contributor II

Re: Is there any bug online with sheet restriction access?

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
New Contributor III

Re: Is there any bug online with sheet restriction access?

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.

USERGROUPSH12SH04SH10SH11SH28SH06SH15SH16SH17SH18SH19SH20SH21SH22SH23SH24SH25SH26SH27SH29SH30
BG75111101111100000000000
BG77111101111100000000000
BG91111101111100000000000

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
New Contributor III

Re: Is there any bug online with sheet restriction access?

Hello,

I don't find a solution to this problem.

Anyone have an idea?

Best regards,

carlos_reyes_qv
Valued Contributor

Re: Is there any bug online with sheet restriction access?

You may find this document useful:

Sheets Security with Section Access

Community Browser