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: 
Chanty4u
MVP
MVP

RE: Issue on access

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

secacc.png

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

1 Solution

Accepted Solutions
NareshGuntur
Partner - Specialist
Partner - Specialist

This works fine for me.

View solution in original post

16 Replies
NareshGuntur
Partner - Specialist
Partner - Specialist

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
MVP
MVP
Author

i hve done intial data reduction

sry ..both r same  spelling mistake

NareshGuntur
Partner - Specialist
Partner - Specialist

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
Creator
Creator

Hi,

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

Chanty4u
MVP
MVP
Author

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
Partner - Specialist
Partner - Specialist

This works fine for me.

NareshGuntur
Partner - Specialist
Partner - Specialist

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
MVP
MVP
Author

yes i hve gvn  upper only  evn thugh its cmg same