topic Re: Need help in section access in QlikView

Need help in section access

vikasshana — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I need help in defining section access. I'm using the below code in order to test whether the section access is working fine or not.

LOAD * INLINE [
Plarform
A
B
C
D
E
];

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, NAME, Platform
USER, HBEU\04741072, Adam, A
USER, HBEU\04741072, Adam, B
ADMIN, HBEU\44082191, Varun, *
USER, HBAP\43848019, Brahma, C
];
Section Application;

As you can see from the above code Adam can access only 'A' and 'B', Varun can access all the Platforms and Brahma can access only 'C'.

I've published the report and forwarded the link to Adam and Brahma and they are saying they can able to see all the platforms but I gave access to only 'A' and 'B' to Adam and 'C' to Brahma. Can you help me on what I'm doing wrong here.

Regards,

Vikas

Re: Need help in section access

kaushiknsolanki — Tue, 28 Nov 2017 11:42:17 GMT

Try this.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, NAME, Platform

USER, HBEU\04741072, Adam, A

USER, HBEU\04741072, Adam, B

ADMIN, HBEU\44082191, Varun,

USER, HBAP\43848019, Brahma, C

];

Section Application;

LOAD * INLINE [

Plarform

];

Also make sure that you have checked the "Initial Data reduction based on Section Access" option in document properties.

Regards,

Kaushik Solanki

Re: Need help in section access

vikasshana — Tue, 28 Nov 2017 12:08:08 GMT

Thanks for the Code kaushik.solanki‌, I changed the code and checked 'Initial Data reduction based on Section Access' still they can able to see A B C D E.

Re: Need help in section access

settu_periasamy — Tue, 28 Nov 2017 12:13:02 GMT

did you try to change the Name as Upper(Name)..?

Re: Need help in section access

vikasshana — Tue, 28 Nov 2017 12:16:30 GMT

I've tried the below code and it still says the same

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, UPPER(NAME), Platform
USER, HBEU\04741072, Adam, A
USER, HBEU\04741072, Adam, B
ADMIN, HBEU\44082191, Varun, A
USER, HBAP\43848019, Brahma, C
USER, HBEU\44067097, Gavin, D
];
Section Application;
LOAD * INLINE [
Platform
A
B
C
D
E
];

Re: Need help in section access

settu_periasamy — Tue, 28 Nov 2017 13:11:44 GMT

No.

Like this..

Section Access;

LOAD * INLINE [
ACCESS, NTNAME, NAME, PLATFORM
USER, HBEU\04741072, ADAM, A
USER, HBEU\04741072, ADAM, B
ADMIN, HBEU\44082191, VARUN, *
USER, HBAP\43848019, BRAHMA, C
];

Section Application;

LOAD * INLINE [
PLATFORM
A
B
C
D
E
];

Re: Need help in section access

vikasshana — Wed, 29 Nov 2017 09:23:14 GMT

Thanks for that, but I changed my code as below and published,

LOAD * INLINE [
ACCESS, NTNAME, NAME, PLATFORM
USER, HBEU\04741072, ADAM, ATM
USER, HBEU\04741072, ADAM, DATABASE
ADMIN, HBEU\44082191, VARUN, *
USER, HBAP\43848019, BRAHMA, DESKTOP
];

Section Application;

LOAD * INLINE [
PLATFORM
ATM
DATABASE
DESKTOP
DMZ ROUTERS AND SWITCHES
F5-LOADBALANCER
FIREWALL DEVICES
FIREWALL RULES
IPS IDS
ISERIES
PROXIES
UNIX/LINUX
WINDOWS SERVER
WIRELESS LAN CONTROLLERS
];

After publishing I've to see all the Platforms but i can able to see only ATM, DESKTOP and DATABASE only.

Re: Need help in section access

jonathandienst — Wed, 29 Nov 2017 09:53:46 GMT

The * wildcard does NOT mean see everything. It means "see all the option listed in the section access table".

To see everything, you will need to include all the possible values of PLATFORM in the SA load.

Re: Need help in section access

jonathandienst — Wed, 29 Nov 2017 09:55:50 GMT

You could use logic like this to generate the necessary extra lines:

PLATFORMS:

LOAD * INLINE [

PLATFORM

ATM

DATABASE

DESKTOP

DMZ ROUTERS AND SWITCHES

F5-LOADBALANCER

FIREWALL DEVICES

FIREWALL RULES

IPS IDS

ISERIES

PROXIES

UNIX/LINUX

WINDOWS SERVER

WIRELESS LAN CONTROLLERS

];

Access:

LOAD 'ADMIN' as ACCESS,

'HBEU\44082191' as NTNAME,

'VARUN' as NAME

AUTOGENERATE 1;

Join(Access)

LOAD PLATFORM Resident PLATFORMS;

Concatenate(Access)

LOAD * INLINE [

ACCESS, NTNAME, NAME, PLATFORM

USER, HBEU\04741072, ADAM, ATM

USER, HBEU\04741072, ADAM, DATABASE

USER, HBAP\43848019, BRAHMA, DESKTOP

];

SECTION ACCESS;

LOAD *

Resident Access;

SECTION APPLICATION;

DROP Table Access;

Re: Need help in section access

PrashantSangle — Wed, 29 Nov 2017 10:15:10 GMT

We can achieve this by simply replacing * with blank as suggested by kaushik.solanki‌ in their 1st reply.

Section Access;

LOAD ACCESS,NTNAME,Upper(NAME) as NAME,upper(Platform) as PLATFORM INLINE [

ACCESS, NTNAME, NAME, Platform

USER, HBEU\04741072, Adam, A

USER, HBEU\04741072, Adam, B

ADMIN, HBEU\44082191, Varun,

USER, HBAP\43848019, Brahma, C

];

Section Application;

LOAD * INLINE [

Plarform

];

Regards,

Re: Need help in section access

vikasshana — Wed, 29 Nov 2017 11:16:22 GMT

Thank you Jonathan, this code is working fine. End-of-the day I've to import all the NTNAME and PLATFORM from excel. How to import excel which have all the NTNAME (including ADMIN) in the above code and which part of the code I've to import the excel?

Re: Need help in section access

Peter_Cammaert — Wed, 29 Nov 2017 15:36:51 GMT

That's a different ball game (and a different question altogether). As nobody has seen what the Excel file contains, it would be best if you post a sample Excel file with representative data (including how you assign platforms to users and how you assign roles to those same users). That would make it easier to convert the script from an INLINE load-based example to something that works for your data source.