topic Re: Section access question in QlikView

Section access question

raju_salmon — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

In my project one of existing qlikview dashboards is showing Section Access table in table viewer. When I check the log file in file location, it does not have Section Access script. in dashboard I checked for hidden script. All options for hidden script are disabled. Can anyone please tell me how/where the section access details would be available?

Thanks in advance.

Regards,

Raju

Re: Section access question

martinpohl — Tue, 11 Jun 2019 09:02:34 GMT

is there a binary load in your script so a datamodel with section access is being loaded?

Regards

Re: Section access question

Gysbert_Wassenaar — Tue, 11 Jun 2019 09:12:21 GMT

If you're seeing a table with the name Section Access then somebody probably didn't create the Access and Application sections correctly.
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Section.htm

Here's an example of how it used:

Section Access; Load * inline [ACCESS,USERID,PASSWORD ADMIN, A,X USER,U,Y ]; Section Application; Load some_stuff from some_source;

Re: Section access question

tresB — Tue, 11 Jun 2019 09:12:20 GMT

Somewhere you are doing wrong. Section access table doesn't appear in table viewer.

Re: Section access question

raju_salmon — Tue, 11 Jun 2019 09:13:55 GMT

Hi Martin,

There is no binary load in script.

Regards,

Raju

Re: Section access question

martinpohl — Tue, 11 Jun 2019 09:35:28 GMT

or maybe an include?

Re: Section access question

raju_salmon — Tue, 11 Jun 2019 12:05:43 GMT

Hi All,

Thanks for your response.
Section access script is not at all showing either while loading the script or in log file after completing the reload. But it is appearing in table viewer. If it is in hidden script, then Edit hidden script option should be enabled. If hidden script is not there then, Create hidden script option should be enabled. But if you observe in the image which I have attached, all options are disabled. How is it possible. Can anyone please tell me.

Thanks in advance.

Regards,

Raju

Re: Section access question

anushree1 — Wed, 12 Jun 2019 05:56:48 GMT

Did you check if if there is any include statement of a qvs file , there could be a possible situation that qvs file is included in the script which has the section access table.

If, not try loading part of the script using exit script and check where the section access table might get loaded.

My thought is that there could be an include statement with a qvs file loading the section access table

Re: Section access question

marcus_sommer — Wed, 12 Jun 2019 07:48:27 GMT

Checking for a prj-folder (which might contain invalid data) might be a further cause.

- Marcus