Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
satishkurra
Valued Contributor II

Section Access Help

Hi

Using the below section access script, i assume user ADAM has ADMIN access and he should be able to see all the data as i represented in * and User PETER should be able to see only JCPenney.

Not sure what is happening, when i log with ADAM, i see only JCPenney.

Can someone help me on the same.

In b/w the below things are taken care

I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.


Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM, *

USER, PETER, PETER, WALLMART

];

Section Application;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];


15 Replies
trdandamudi
Honored Contributor

Re: Section Access Help

Do you have data for Wallmart in your dashboard ?

satishkurra
Valued Contributor II

Re: Section Access Help

This is just a test data. I don't have data for JCPenney as well

trdandamudi
Honored Contributor

Re: Section Access Help

Satish,

Please try the attached and let me know. I used your data so when you login as :

Adam you will see all the data and when you login as Peter you will see only 'Wallmart'

if you want in "Security" tab you can also check "Admin Override Security"

Hope this helps.

Re: Section Access Help

Hi,

Remove '*' and try..

Capture.JPG

MVP
MVP

Re: Section Access Help

satishkurra
Valued Contributor II

Re: Section Access Help

This is strange. * indicates all data right . any reason to remove *?

Re: Section Access Help

Hi Satish,

See here..  Re: Section Access "Star"

Capture.JPG

May be you can try like

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, LINK
ADMIN, ADAM, ADAM, *
USER, PETER, PETER, WALLMART
USER, USER,PASSWORD,JCPENNEY
]


Section Application;
Provider:
LOAD * Inline [
LINK
JCPENNEY
WALLMART
]
;

perumal_41
Valued Contributor II

Re: Section Access Help

use blank as per sethu said

for reference

Re: Section Access Help

try like this

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM, *

USER, PETER, PETER, WALLMART

];

Section Application;

START is *;


STAR is *;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];

Community Browser