QlikView Reload Issues

[#1]

I'm having an issue with my a QV document which hopefully someone can help me with.

When i add some script to the document in designer and then reload, the new data appears on my document. However the new data does not appear on the document through my Access Point.

Then when I close my document in designer and re-open, the "new" data from the initial reload has disappeared. Has anyone had any issues with this before?

In summary... add script to document - new data appears - save document - exit document - reopen document - new data disappears.

[#2]

Hi,

Do you have any Session  access on your document? this could cause the problem.

- Sridhar

[#3]

Thanks for the reply...

I have section access on the document, a username and password is required to open it. How can this be the issue?

[#4]

Are you using Admin loging to reload the document? if not Try to use admin user name and password to reload your document. This may solve the problem.

- Sridhar

[#5]

Yes, I'm adding script to the code in the designer which requires admin controls.

[#6]

Basically I have a document with a list of customers (among other things). I tried to add a new customer through an Inline Load in the script and when i reloaded the customer appeared successfully in the listbox.

However, once I saved and exited my application and reopened it, the new customer disappears.

I have now entered the customer in the database which QV is pulling the customer information from. Currently the customer is in the database and is recognised by QV when i refresh, however once i exit the application it disappears.

Could it be a memory issue?

[#7]

Hi,

This is not the memory issue as far as i know. Are you using this customer field on session access? if so check whether the customer which you have added is included in session access table.

- Sridhar

[#8]

No, the customer data has nothing to do with the section access. I have say 100 different customers in the list box, when i add this new one to the database and reload it can be seen on the document.

However when i save and close, it disappears... Words cannot express my frustration

[prieper · Accepted solution]

Looks very much like a problem with SECTION ACCESS though.

Suggest to remove this part in your script and furthermore replace it with

Section Access;

    LOAD * INLINE [

        ACCESS, USERID, PASSWORD

        ADMIN, *, *];

Section Application;

And see whether you have all data visible after reload.

If affirmative you may continue then in this document and rebuild your access-rules.

HTH
Peter

[#10]

The section access is pulled from a spreadsheet.

section access;

Load [ACCESS],
[USERID],
[PASSWORD],
CUST_ID as analysis_a,
OMIT
FROM [\\dfhdfd\QlikViewReports\SecurityDemo.xls] (biff, embedded labels, table is Access$);

section application;

When I update the document with different data it reloads and saves perfectly, however when i input these details into the script then I have the initially stated issue.