Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
miguelbraga
Valued Contributor 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
Highlighted
krishna_2644
Valued Contributor III

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

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
Highlighted
MVP
MVP

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

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

Highlighted
Partner
Partner

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

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?

Highlighted
miguelbraga
Valued Contributor III

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

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

Highlighted
krishna_2644
Valued Contributor III

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

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

Highlighted
Partner
Partner

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

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

Highlighted
miguelbraga
Valued Contributor III

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

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
Highlighted
krishna_2644
Valued Contributor III

Re: Using Section Access With a single Excel Sheet in Qlikview QVD

Awesome. Happy Qliking.