RE: Issue on access

[Chanty4u]

hi all ,

I hve issue on section access.

As i have  user list and permision sheet on excel

as i am opening with  admin  dashboard shwng all

but wen i opening with user  ...  it is also shwng common filed values

example... i open with the user  raju :  it will show the listbox values like    cricket  only   but or me it is shwng  cricket and ball also

any help on this

Thnks in advance

sureshs

[#2]

QlikView Section Access Examples

A Primer on Section Access

https://community.qlik.com/docs/DOC-9039

[NareshGuntur]

Was "Initial Data Reduction based on Section Access" is checked?

As user Raju, are you seeing only cricket and ball or all the values as well.

A small notice. Cricket has two different spellings in your screenshot. Sorry if it is wantedly added.

Cheers,

Naresh

[Chanty4u]

i hve done intial data reduction

sry ..both r same  spelling mistake

[NareshGuntur]

So back to my question

As user Raju, are you seeing only cricket and ball or all the values as well.

Can you paste your section access script here?

Cheers,

Naresh

[rajeshforqlikvi]

Hi,

Are you using section access through NT name or basic one ?

[Chanty4u]

AS I LOADED EXCEL DATA  of access

ECTION Access;

LOAD USERID,

     PASSWORD,

     ACCESS

FROM

[..xls]

(biff, embedded labels, table is Sheet1$);

SECTION Application;

LOAD USERID,

     track

FROM

[..xls]

(biff, embedded labels, table is Sheet2$);

[NareshGuntur · Accepted solution]

This works fine for me.

[NareshGuntur]

Ok. I think issue is because...

The screenshot where you have shown the list of names, they are in lower case.

Try converting them to upper case using upper() while loading.

And that is why your section access is not working.

So, the userid in the Section Access and Section Application are not matching.

Cheers,

Naresh

[Chanty4u]

yes i hve gvn  upper only  evn thugh its cmg same