topic Re: Section Access in QlikView

Section Access

Mon, 26 Jan 2026 18:19:17 GMT

I have to provide Section Access with multiple fields as below. This is the user access list. How can this be done using the section access?

field

field1	field2	field 3	User
sla1	legacy	mpt	user1
sla2	legacy	mpt	user1
sla3	sap crm	rms	user1
sla4	go solution	rms	user2
sla5	orda	rms	user2
sla6	orda	mhs	user2
sla8	mdiv	mhs	user2
sla9	siebel	mpt	user3

Re: Section Access

maxgro — Mon, 27 Jan 2014 15:23:17 GMT

read this, it should help

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

Re: Section Access

fabio182 — Mon, 27 Jan 2014 21:43:45 GMT

Hola Anita tienes que realizar algo como lo siguiente:

//*******************************************************************************************

//Seguridad por Pestaña

Section Access;

SATABLE:

LOAD ACCESS,

NTNAME,

SAUSER

FROM

..\Include\Seguridad_Acceso_Hojas_Manufactura.xlsx

(ooxml, embedded labels, table is ListaUsuarios);

Section Application;

star is *;

LOAD SAUSER,

CTE,

CTI,

CTT,

CV,

ManoObraDirecta,

ManoObraTotal,

EficienciaMecanica,

UsodeCapacidad,

RendimientodeInsumos,

EjecutadovsProgramadoEmbotellado,

[Calidad(ProductoNoDefectuoso)Inyeccion],

[Calidad(ProductoNoDefectuoso)Tapas],

AccidentabilidadPlantaEmbotellado,

UtilizaciondeEnergiaElectricaEmbotellado,

CostodelMantenimiento,

UtilizaciondeAguaCrudaEmbotellado,

AseguramientodelaCalidad,

RotaciondeInventariosRefacciones

FROM

..\Include\Seguridad_Acceso_Hojas_Manufactura.xlsx

(ooxml, embedded labels, table is ListaUsuarios);

//*******************************************************************************************

ACCESS	NTNAME	SAUSER	CTE	CTI	CTT	CV	ManoObraDirecta	ManoObraTotal	EficienciaMecanica	UsodeCapacidad	RendimientodeInsumos	EjecutadovsProgramadoEmbotellado	Calidad(ProductoNoDefectuoso)Inyeccion	Calidad(ProductoNoDefectuoso)Tapas	AccidentabilidadPlantaEmbotellado	UtilizaciondeEnergiaElectricaEmbotellado	CostodelMantenimiento	UtilizaciondeAguaCrudaEmbotellado	AseguramientodelaCalidad	RotaciondeInventariosRefacciones
ADMIN	AJEGROUP\PE3DEV1	AJEGROUP\PE3DEV1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
ADMIN	AJEGROUP\PE3DEV8	AJEGROUP\PE3DEV8	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
ADMIN	AJEGROUP\QVSERVER	AJEGROUP\QVSERVER	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

Espero te pueda ayudar.

Re: Section Access

Mon, 27 Jan 2014 22:17:06 GMT

Unfortunately I dont understand Spanish dear... but I am trying my best to understand the concept from what you have written.. Really appreciate your help.

Re: Section Access

Carlos_Reyes — Mon, 27 Jan 2014 22:27:40 GMT

The post from HC pubished by Massimo is the way to go! I had a similar issue some time ago and the method described by Henric it's the best I've found so far.