topic section access from excel file in QlikView

section access from excel file

Meg00 — Fri, 15 Nov 2024 23:38:08 GMT

Hello everyone!

I haven't had that much experience with section access and would be thankful for some help.

The end user app has dimension Region with values "North", "Central", "South" and "Others".

My access file looks as below, my aim is to create a clean QVD to load into the end user app. Do I have to repeat rows for users with more than one region? What is the best way of doing this?

Name	AD acc	North	Central	South	Others
name1	acc1	yes
name2	acc2			yes
name3	acc3		yes
name4	acc4	yes	yes	yes	yes
name5	acc5	yes	yes	yes	yes
name6	acc6	yes	yes	yes	yes
name7	acc7	yes	yes	yes	yes
name8	acc8	yes	yes	yes	yes
name9	acc9	yes	yes	yes	yes
name10	acc10	yes	yes	yes	yes
name11	acc11	yes	yes	yes	yes
QlikView Admin account	local\qvadmin	yes	yes	yes	yes

Re: section access from excel file

QFabian — Fri, 13 Nov 2020 12:40:45 GMT

hi, here attached you have an example of excel file for section access.

This is the script :

Section Access;

LOAD
ACCESS,
NTNAME,
[USERID],
[PASSWORD],
GROUP,
[PROFILE]
FROM [seguridad.xls] (biff, embedded labels, table is Access$);

Section Application;
star is *;

Grupos:
LOAD
GROUP,
Zona
FROM [seguridad.xls] (biff, embedded labels, table is Aplication$);

Re: section access from excel file

Meg00 — Fri, 13 Nov 2020 14:33:06 GMT

Thank you,

but I can not change how the excel file looks.

managed to get a clean table with crosstable function.

The only question remaining is, will it work is the same user has multiple rows in the table when that user should have access to all Regions?

Re: section access from excel file

zjalalacssi — Fri, 20 Dec 2024 07:45:36 GMT

Hello QFabien

I am looking to use a section access from excel as well, your example is very helpfull, therefore, where do you use the sheet "Perfiles" from your excel

in my case, i just need a "Access" like yours and a "profile" sheet but in your script, you don't load the profile sheet.

Can you please show me how do you use the "profile" sheet

Thank you

Re: section access from excel file

QFabian — Sat, 21 Dec 2024 15:33:28 GMT

Sure @zjalalacssi :

//__________________________________________________________________________________________________________________________________

//Seguridad de acceso por Hoja

UsuariosHoja:

LOAD

PROFILE,

SH01,

SH02

FROM seguridad.xls (biff, embedded labels, table is Perfiles$);

//LOAD * INLINE [

// PROFILE, SH01, SH02

// ADMIN1, 1, 1

// USER1, 1, 0

//];

With that, for example, you can use the field 'SH01' in sheet properties to show it o not dependind of the user profile :

Re: section access from excel file

QFabian — Sat, 21 Dec 2024 15:37:55 GMT

Hi @Meg00 , for that cases, you can use * :

Read this in Qlik Help :

Managing data security with Section Access

https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm