topic Re: Document with Section Access opens with no authentification in QlikView

Document with Section Access opens with no authentification

Anonymous — Tue, 22 Dec 2015 22:06:18 GMT

I have evoked Section Access into my QV document as follows:

Section Access;
Directory;
LOAD ACCESS,
USERID,
PASSWORD,
RETAILPHARMACY,
OMIT,
PATENTS,
FDA,
GENERICS,
SHOPPING,
PLAZA_ANALYTICS,
_VIEWGROUP
FROM
[..\Data Files\SectionAccess.xlsx]
(ooxml, embedded labels, table is SectionAccess);

To my surprise, the document is opening without entering any USERID and PASSWORD credentials, What could be the cause for this?

Regards.

Re: Document with Section Access opens with no authentification

maxgro — Tue, 22 Dec 2015 22:53:25 GMT

Did you check in menu --> Settings --> Document Properties --> Opening tab

Initial data reduction............

Remember to make a backup of the .qvw before using the section access.

Re: Document with Section Access opens with no authentification

Anonymous — Tue, 22 Dec 2015 23:00:59 GMT

Many thanks Maxgro. The settings are in place as per the following screen shot:

Regards

Re: Document with Section Access opens with no authentification

maxgro — Tue, 22 Dec 2015 23:07:49 GMT

could you post the .qvw or a small example?

Re: Document with Section Access opens with no authentification

Anonymous — Tue, 22 Dec 2015 23:42:12 GMT

Maxgro

Please find attached sample application

Re: Document with Section Access opens with no authentification

PradeepReddy — Wed, 23 Dec 2015 05:37:05 GMT

it seems the bellow fields are not existing in your application but using in Section access

PATENTS, FDA, GENERICS, SHOPPING, PLAZA_ANALYTICS

Re: Document with Section Access opens with no authentification

PradeepReddy — Wed, 23 Dec 2015 05:44:44 GMT

Hope your are providing the sheet level security based on the specific group.

please see the attachment for more info on section access...

Re: Document with Section Access opens with no authentification

tresB — Wed, 23 Dec 2015 06:07:53 GMT

Could you share your SectionAccess.xlsx or at least a sample screen shot?

Re: Document with Section Access opens with no authentification

sasikanth — Wed, 23 Dec 2015 07:36:54 GMT

HI,

Might be the load of SectionAccess.xlsx table filed

Re: Document with Section Access opens with no authentification

maxgro — Wed, 23 Dec 2015 08:12:29 GMT

and I also suggest to start

- without binary load

- with one field in the section access table ( _VIEWGROUP)

Re: Document with Section Access opens with no authentification

Anonymous — Wed, 23 Dec 2015 08:29:33 GMT

Thank you Tresco Please find herewith Section Access Table attached

Re: Document with Section Access opens with no authentification

Anonymous — Wed, 23 Dec 2015 08:30:25 GMT

Thanks Pradeep

Re: Document with Section Access opens with no authentification

Anonymous — Wed, 23 Dec 2015 08:30:56 GMT

Thank you for the document

Re: Document with Section Access opens with no authentification

Anonymous — Wed, 23 Dec 2015 08:31:33 GMT

Thanks Sunny, i have posted the SectionAccess file

Re: Document with Section Access opens with no authentification

tresB — Wed, 23 Dec 2015 08:39:01 GMT

I can't find the attachment.

Re: Document with Section Access opens with no authentification

Anonymous — Wed, 23 Dec 2015 08:48:43 GMT

Pradeep thank you, those fields are used elsewhere in the rest of the documents to hide sheets. These sheets are not part of the sample which is a reduced version of the application.

Re: Document with Section Access opens with no authentification

Anonymous — Wed, 23 Dec 2015 09:26:46 GMT

I have re-attached the file, seems it was not attached the first time.

Regards.

Re: Document with Section Access opens with no authentification

tresB — Wed, 23 Dec 2015 09:33:06 GMT

Remove '*' from USERID column and reload the app.

Re: Document with Section Access opens with no authentification

sasikanth — Wed, 23 Dec 2015 09:33:50 GMT

Hi,

If possible please post your SectionAccess.xlsx file

it would be more helpful .

Re: Document with Section Access opens with no authentification

Anonymous — Wed, 23 Dec 2015 10:34:05 GMT

Hi posted above