Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

pgrs4219
Not applicable

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
Not applicable

Re: Session Access?

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
Not applicable

Re: Session Access?

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
Not applicable

Re: Session Access?

Hi Maxgro,

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

pgrs4219
Not applicable

Re: Session Access?

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
Not applicable

Re: Session Access?

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
Not applicable

Re: Session Access?

Thanks you maxgro,perfectly working.