topic QlikView Reload Issues in QlikView

QlikView Reload Issues

Fri, 06 May 2011 08:12:29 GMT

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.

QlikView Reload Issues

Fri, 06 May 2011 08:43:07 GMT

Hi,

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

- Sridhar

QlikView Reload Issues

Fri, 06 May 2011 08:48:33 GMT

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?

QlikView Reload Issues

Fri, 06 May 2011 08:59:16 GMT

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

QlikView Reload Issues

Fri, 06 May 2011 09:04:03 GMT

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

QlikView Reload Issues

Fri, 06 May 2011 10:02:19 GMT

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?

QlikView Reload Issues

Fri, 06 May 2011 10:25:57 GMT

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

QlikView Reload Issues

Fri, 06 May 2011 10:58:27 GMT

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

QlikView Reload Issues

prieper — Fri, 06 May 2011 12:37:59 GMT

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

Re: QlikView Reload Issues

Fri, 06 May 2011 13:17:41 GMT

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.

QlikView Reload Issues

prieper — Fri, 06 May 2011 14:24:41 GMT

Then you need to recheck your conditions - what about taking them out and then add them one-by-one (CUST_ID, OMIT)?

Peter

QlikView Reload Issues

rwunderlich — Fri, 06 May 2011 14:28:03 GMT

As others have suggested, it looks like a section access issue. When you reload, section access is not applied. Section Access is applied only on document open. So when you reopen the doc, the Section Access reduction is applied.