topic Section Access in QlikView

Section Access

Wed, 29 Sep 2010 13:34:03 GMT

Hi,

I have used the inline Wizard to prompt to user for username and Password to open the QVW file. Also i have enabled the option Settings-Document Properties-Initial Selection based on Section Access. Now when i trying to open the QVW file it is prompting for user name and Password. but once the username and password are provided it is throwing an error failed to open the document.

Actually i should have choosen the option Settings-Document Properties-Initial data reduction based on Section Access.

Now i am not able to open the QVW file. I have not taken the backup of the file. Is there any way to open the document.

Regards,XXX

Re. :Section Access

martin59 — Wed, 29 Sep 2010 13:52:26 GMT

Unfortunately, I think you have no way to re-open your document.

But if you don't check the "prohibit binary load" option, you have to create a new QV app and load datas from old document with binary load.

Section Access

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 14:15:19 GMT

Hello,

I agree with Martin. But if you had checked "Initial Selection..." it shouldn't happen, as it only does a selection if possible, otherwise it opens the document anyway.

When you reduce data is when you are actually deleting from memory, which can cause what it seems is happening to you.

Try a binary load as suggested. If not, you won't be able to recover your document.

Anyway, I'd recommend you to go to your Settings, User Preferences, Save tab, select "Save before reload" and "Use backup".

Regards.

Section Access

Wed, 29 Sep 2010 15:08:06 GMT

Hi,

Thanks for suggestion . As suggested I am trying to recover using the Binary Load as

Test:

Binary d:\Gau1.qvw;

but i am getting the error as unkown statement.

Also (a)would like to know the how qlikview behaves or works when

Initial data reduction based on section access is choosen and when Initial selection based on section access.

Since i want to know the feasbility of the below.

(a) Only one QVW file will be used for multiple customer.Once the user is accessing the QVW file he should be able to access the data for the customer whom he has been tagged. Also based on the role he should have the access.For E.g If Alex is tagged to customer A and his role is sales executive. when Alex is accessing the QVW file he should be able to see only the Customer A data and again specific to sales sheet.

Regards,xxx

Section Access

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 15:16:07 GMT

Hello,

There are several sample codes on how reduction fields works in this and this post among many others.

Hope that helps.

Section Access

Wed, 29 Sep 2010 15:19:41 GMT

Thanks Miguel A. Baeyens

As suggested I am trying to recover the file using the Binary load . but getting error as unkown statement.Please find the script and correct me if i am wrong.

Binary d:\Gau1.qvw;

Section Access

pover — Wed, 29 Sep 2010 15:25:53 GMT

Make sure the binary statement is in the first line of your script and that you ony do one binary load.

Regards.

Section Access

Miguel_Angel_Baeyens — Wed, 29 Sep 2010 15:26:54 GMT

Hello,

Syntax seems correct, although I'd quote the file:

Binary "d:\Gau1.qvw;"

Anyway, use the wizard clicking "QlikView File..." in the script editor. That will help.

Section Access

Thu, 30 Sep 2010 05:30:04 GMT

Hi karl Pover,

Thanks for your suggestion. I was using Binary load statement after the SET variables. hence i was getting the error. Now i have removed the SET variables and kept only the Binary Load statement and it is working fine.

Correct me if i am wrong...

Binary load just take the data from the another QVW file. we will not be able to reload to get the latest data. Also we will not be able to get the structure of the script details.

Section Access

Miguel_Angel_Baeyens — Thu, 30 Sep 2010 07:33:12 GMT


XXX wrote:Binary load just take the data from the another QVW file. we will not be able to reload to get the latest data. Also we will not be able to get the structure of the script details.

That's right. Binary will take data both from section access (if any) and section application.

Regards.

Section Access

pover — Thu, 30 Sep 2010 19:04:13 GMT

Correct, a binary load will not give you the script and so you won't be able to reload to get the latest data.