topic Re: Removing Security - Removing Section Access in QlikView

Removing Security - Removing Section Access

Mon, 27 Jul 2009 17:54:36 GMT

I wish to create a demo version of a QV application that I have written for a client, I am initially referencing all data from the Clients QVW using the Binary load function and then dropping the client sensitive data tables and then importing new data from XL sheets with sensible scrambled data.

The issue is that the client file has Section access applied and as a result my so does my new demo application, how can I remove the pop up request for a username and password in my demo version?

Kindest Regards
Paul Bartram
Pythagoras Communications Ltd.

Removing Security - Removing Section Access

Mon, 27 Jul 2009 19:00:54 GMT

Hi Paul,

Got this from the HELP file:

The binary statement is used for loading the access and data parts of a QlikView document. It does not load the layout information. Only one binary statement is allowed in the script and it can only be put as the first statement of a script.

I think that the only way to get a QVW without section access is to load the qvw without de section access script. You can comment this part of the script and save the DEMO file as a new qvw file. You'll need to prefrom a reload of course.

Greetz
Robbie

Removing Security - Removing Section Access

Mon, 12 Apr 2010 13:57:18 GMT

Dear Paul

did you already solved this problem? We have the same situation.

Milda

Removing Security - Removing Section Access

Tue, 13 Apr 2010 09:01:33 GMT

Hi Paul,

I've just found a solution. Binary load should always be the first statement in the load script, so we need to write this in hidden script:

BINARY "example.qwv";

Section Access;

In this case, Section access is removed. New qwv file will not inherit Section access from "example.qwv" file.

Milda

Removing Security - Removing Section Access

Fri, 03 Dec 2010 02:06:13 GMT

I had the same issue and tried using your solution. However, the script fails everytime with the "General Script error". Not sure why. But the moment I just kept Binary load and removed the "Section Access;" line from the script, the dashboard was reloaded fine. Any clue?

Re: Removing Security - Removing Section Access

Anonymous — Thu, 22 May 2014 10:55:30 GMT

correct answer

Re: Removing Security - Removing Section Access

SunilChauhan — Thu, 22 May 2014 10:58:56 GMT

document properties-> intial data reduction based on binary

uncheck this

docuement properties-> intial data reduction based on sction access

uncheck this

hope this helps