topic Session Access? in QlikView

Session Access?

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

Hi Community,

I have a requirement that needs to implement Session Access by Field name let say "CITY" i need only few user see all the city's data rest need to see few..

Here is the script that i used but no success.

Section Access;

LOAD ACCESS,

NTNAME,

CITY

FROM

[..\..\..\LOCAL_SOURCES\CITY\Session_ Access.xlsx]

(ooxml, embedded labels, table is [Authentication]);

Section Application;

LOAD * INLINE [

%dim_CITY, CITY

A, A

B, B
C, C
D, D
E, E
F, F
G, G
H, H
I, I
J, J
K, K
L, L
M, M
N, N
O, O
P, P
Q, Q

];

AM attaching the XL file that i used.please help me with this.

Thanks

Re: Session Access?

Gysbert_Wassenaar — Wed, 21 Sep 2016 11:17:31 GMT

You need to use a separate line for each city in the section access table. Comma separated strings will not be matched with individual city values in the application tables.

Re: Session Access?

maxgro — Wed, 21 Sep 2016 12:15:07 GMT

maybe

Section Application;

LOAD * INLINE [

%dim_CITY, CITY

A, A

B, B

C, C

D, D

E, E

F, F

G, G

H, H

I, I

J, J

K, K

L, L

M, M

N, N

O, O

P, P

Q, Q

];

SECTION Access;

LOAD ACCESS,

NTNAME,

SubField(CITY, ',') as CITY

FROM

SessionAccess.xlsx

(ooxml, embedded labels, table is [Qv Authentication]);

* in section access is for all listed values, not for all values

Re: Session Access?

pgrs4219 — Wed, 21 Sep 2016 13:15:30 GMT

Hi Maxgro,

Thanks for your reply,what should i used to let some users to see all the subfilelds inside the CITY.

Re: Session Access?

pgrs4219 — Wed, 21 Sep 2016 13:16:52 GMT

Hi Gysbert,

Thanks for your reply,Can you please share the exact script as am new i am unable to get it.

Thanks

Re: Session Access?

Colin-Albert — Wed, 21 Sep 2016 13:27:58 GMT

Adding a user record with * in the city column will allow that user to see all cities that exist in the Section Access table.

marcus_sommer has put together a good post with links to many items on Section Access.
This should give answers to your questions. Section Access

Re: Session Access?

pgrs4219 — Wed, 21 Sep 2016 14:42:18 GMT

Thanks you maxgro,perfectly working.