section access from excel file

[Meg00]

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

[QFabian]

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$);

[Meg00]

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?

[zjalalacssi]

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

[QFabian]

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 :

[QFabian]

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/m...