Section Access

[#1]

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

[martin59]

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.

[Miguel_Angel_Baeyens]

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.

[#4]

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

[Miguel_Angel_Baeyens]

Hello,

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

Hope that helps.

[#6]

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;

[pover · Accepted solution]

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

Regards.

[Miguel_Angel_Baeyens]

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.

[#9]

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.

[Miguel_Angel_Baeyens]

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.