topic RE: Issue on access in QlikView

RE: Issue on access

Chanty4u — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: RE: Issue on access

Fri, 08 Jan 2016 11:58:25 GMT

QlikView Section Access Examples

A Primer on Section Access

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

Re: RE: Issue on access

NareshGuntur — Fri, 08 Jan 2016 12:06:40 GMT

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

Re: RE: Issue on access

Chanty4u — Fri, 08 Jan 2016 12:09:36 GMT

i hve done intial data reduction

sry ..both r same spelling mistake

Re: RE: Issue on access

NareshGuntur — Fri, 08 Jan 2016 12:13:51 GMT

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

Re: RE: Issue on access

rajeshforqlikvi — Fri, 08 Jan 2016 12:14:10 GMT

Hi,

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

Re: RE: Issue on access

Chanty4u — Fri, 08 Jan 2016 12:16:20 GMT

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$);

Re: RE: Issue on access

NareshGuntur — Fri, 08 Jan 2016 12:27:25 GMT

This works fine for me.

Re: RE: Issue on access

NareshGuntur — Fri, 08 Jan 2016 12:31:24 GMT

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

Re: RE: Issue on access

Chanty4u — Fri, 08 Jan 2016 12:48:46 GMT

yes i hve gvn upper only evn thugh its cmg same

Re: RE: Issue on access

NareshGuntur — Fri, 08 Jan 2016 12:54:00 GMT

Have you tried checking the qvw which I have shared?

Were you doing something different than that?

Can you share the qvw which you are using removing all the other script and data?

Re: RE: Issue on access

Chanty4u — Fri, 08 Jan 2016 12:58:19 GMT

am loading the data from excel...not inline...

inline is working fyn...

Re: RE: Issue on access

NareshGuntur — Fri, 08 Jan 2016 13:00:35 GMT

Ideally it should not matter.

Or can you attach the excel sheet here for reference with those two fields

Re: RE: Issue on access

Chanty4u — Fri, 08 Jan 2016 13:08:02 GMT

thnx naresh fr ur response...

as the issue was fixed.

now its wrkng fyn enough...

Re: RE: Issue on access

NareshGuntur — Fri, 08 Jan 2016 13:10:35 GMT

Cool.

Is it the issue with the lower case?

Re: RE: Issue on access

Chanty4u — Fri, 08 Jan 2016 13:13:07 GMT

no...some tables are not mapping ...we done join on that so its wrked nw

Re: RE: Issue on access

Chanty4u — Sat, 09 Jan 2016 10:09:18 GMT

basic only