Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
miguelbraga
Partner - Specialist III
Partner - Specialist III

Using Section Access With a single Excel Sheet in Qlikview QVD

Hi guys,

I'm a beginner Qlikview Developer and I'm struggling with a problem. I've seen lots of people using INLINE Tables when using Section Access and I understand how that works, but I need to implement a similar using a Excel Sheet. My Excel Sheet looks like this:

ACCESSUSERIDPASSWORDUNIDADE_DE_NEGOCIOCONSULTORIOTRADUCAO
ADMINAdministradorAdmin**Administrador
USERProducaoqlik**Produção
USERConsultorio_Gqlik**Consultório Geral
USERConsultorio_G_Ana_qlikAnálises*Consultório de Análises
USERConsultorio_G_Car_qlikCardiologia*Consultório de Cardiologia
USERConsultorio_Car_1qlikCardiologiaCons.Cardiol. 1

Consultório de Cardiologia 1

I've loaded this as:

SECTION ACCESS;

LOAD

     UPPER(ACCESS) AS ACCESS,

     UPPER(USERID) AS USERID,

     UPPER(PASSWORD) AS PASSWORD,

     UPPER(UNIDADE_DE_NEGOCIO) AS UNIDADE_DE_NEGOCIO,

     UPPER(CONSULTORIO) AS CONSULTORIO

FROM

[..\Dados\dbs\Section Access.xls]

(biff, embedded labels, table is Folha5$);

SECTION APPLICATION;

I have this two fields in the QVD:

  • Unidade_Negocio
  • Consultorio

What I really need is when I enter with one user that user sees what is defined in the Excel Sheet. What I'm doing wrong? What I need to change to get the results I need?

Many Thanks

Miguel Braga

1 Solution

Accepted Solutions
krishna_2644
Specialist III
Specialist III

Please See attached.

this will give you some idea on using Section Access.

Admin can see all the fields and all the data

User1 can only see ANALISES,   and  CONS.CARDIOL.1 from  UNIDADE_DE_NEGOCIO and CONSULTORIO

User2 can only see CARDIOLOGIA,   and  CONS.CARDIOL.2 from  UNIDADE_DE_NEGOCIO and CONSULTORIO

User3 can only see both ANALISES ,CARDIOLOGIA,   and  CONS.CARDIOL.1,CONS.CARDIOL.2 from  UNIDADE_DE_NEGOCIO and CONSULTORIO

Thanks

View solution in original post

7 Replies
maxgro
MVP
MVP

I think the problem isn't excel or inline table as you can read the section access from excel, inline, a database, etc...

First use uppercase for section access field values

Second, you have 2 fields (or 3?) in section access, read here for an example

Basics for complex authorization

stigchel
Partner - Master
Partner - Master

There is no problem in loading the table from excel, I do it all the time. Please check the following

1:

  • Unidade_Negocio
  • Consultorio

These fields in the section application should also be in capitals, contents of these fields as well

2: In the Settings\document properties\Opening tab is the initial data reduction based on section access checked?

miguelbraga
Partner - Specialist III
Partner - Specialist III
Author

This is what I entend to do:


  1. The user with the ID: Administrador sees available all possible values in the field Unidade_Negocio and all possible values in the field Consultorio.
  2. The user with the ID: Producao sees available all possible values in the field Unidade_Negocio and all possible values in the field Consultorio.
  3. The user with the ID: Consultorio_G sees available all possible values in the field Unidade_Negocio and all possible values in the field Consultorio.
  4. The user with the ID: Consultorio_G_Ana_ should only sees available Análises in the field Unidade_Negocio and all possible values in the field Consultorio.
  5. The user with the ID: Consultorio_G_Car_ should only sees available Cardiologia in the field Unidade_Negocio and all possible values in the field Consultorio.
  6. The user with the ID: Consultorio_Car_1 should only sees available Cardiologia in the field Unidade_Negocio and Cons.Cardiol. 1 in the field Consultorio.

I've modified the Unidade_Negocio fields like this:

  • UPPER(Consultorio) AS CONSULTORIO,

and modified the field Consultorio to this:

  • UPPER(Unidade_Negocio) AS UNIDADE_NEGOCIO,

in my two tabs with two separate loads from two diferent (.qvd).

The only three possible values of Unidade_Negocio is

  • Análises
  • Cardiologia
  • Imagiologia

And one of the possible values of Consultorio is:

  • Cons.Cardiol. 1


I've also checked in the document as you sugested like this

Sem Título.png

And after reload the project with the user with the ID: Consultorio_G_Ana_, it appears I have access denied. What I'm doing wrong, what I need to change more to get the expected results?


Thanks for the reply,

Miguel

krishna_2644
Specialist III
Specialist III

Please See attached.

this will give you some idea on using Section Access.

Admin can see all the fields and all the data

User1 can only see ANALISES,   and  CONS.CARDIOL.1 from  UNIDADE_DE_NEGOCIO and CONSULTORIO

User2 can only see CARDIOLOGIA,   and  CONS.CARDIOL.2 from  UNIDADE_DE_NEGOCIO and CONSULTORIO

User3 can only see both ANALISES ,CARDIOLOGIA,   and  CONS.CARDIOL.1,CONS.CARDIOL.2 from  UNIDADE_DE_NEGOCIO and CONSULTORIO

Thanks

stigchel
Partner - Master
Partner - Master

When I tried replicating your problem I had a problem with the space in "Cons.Cardiol. 1", maybe you have a problem with that as well? Anyway I have attached a working example from your data (passwords as well), see attached

miguelbraga
Partner - Specialist III
Partner - Specialist III
Author

Your answer helped me a lot. I've used the table bellow to correctly make my Section Access Table:

     

ACCESSUSERIDPASSWORDUNIDADE_DE_NEGOCIOCONSULTORIO
ADMINAdministradorAdminAnálisesCons.Análises 1
ADMINAdministradorAdminAnálisesCons.Análises 2
ADMINAdministradorAdminImagiologiaCons.Imagiol. 1
ADMINAdministradorAdminImagiologiaCons.Imagiol. 2
ADMINAdministradorAdminCardiologiaCons.Cardiol. 1
ADMINAdministradorAdminCardiologiaCons.Cardiol. 2
USERConsultorio_GqlikAnálisesCons.Análises 1
USERConsultorio_GqlikAnálisesCons.Análises 2
USERConsultorio_GqlikImagiologiaCons.Imagiol. 1
USERConsultorio_GqlikImagiologiaCons.Imagiol. 2
USERConsultorio_GqlikCardiologiaCons.Cardiol. 1
USERConsultorio_GqlikCardiologiaCons.Cardiol. 2
USERConsultorio_G_Ana_qlikAnálisesCons.Análises 1
USERConsultorio_G_Ana_qlikAnálisesCons.Análises 2
USERConsultorio_G_Car_qlikCardiologiaCons.Cardiol. 1
USERConsultorio_G_Car_qlikCardiologiaCons.Cardiol. 2
USERConsultorio_Car_1qlikCardiologiaCons.Cardiol. 1
krishna_2644
Specialist III
Specialist III

Awesome. Happy Qliking.