Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pgrs4219
Contributor III
Contributor III

Session Access?

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

6 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
maxgro
MVP
MVP

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

pgrs4219
Contributor III
Contributor III
Author

Hi Maxgro,

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

pgrs4219
Contributor III
Contributor III
Author

Hi Gysbert,

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

Thanks

Colin-Albert

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

pgrs4219
Contributor III
Contributor III
Author

Thanks you maxgro,perfectly working.