topic Re: Partial Reload problem in QlikView

Partial Reload problem

Tue, 14 Feb 2012 08:15:09 GMT

Hi,

Can any one tell me how to do partial reload in script i have nearly 15 database tables in my datamodel if i change any table i have to reload the total script every time its taking quit sime time but i want to referesh only one table and where we can find the reload option from script..........how to do this..

Regards,

Anil

Re: Partial Reload problem

jagan — Tue, 14 Feb 2012 08:20:00 GMT

Hi,

I think there is no option to load only one table in script.

But you can check the data by loading limited number of records.

In Script window click the Debug option

and Check Limit Load option and give number of records (10/100/1000 as you wish).

Regards,

Jagan.

Partial Reload problem

Tue, 14 Feb 2012 08:53:58 GMT

Hi Anil,

please search QV Help for ADD or REPLACE.

Put one of these functios in front of a LOAD or SQL Select statement and use "Partial Reload":

Main Manue => File => Partial Reload

Now only tables will be loaded with an ADD or REPLACE in front of a LOAD or SELECT statement.

Hope this helps.

Good luck!

Rainer

Partial Reload problem

Tue, 14 Feb 2012 10:03:18 GMT

You can detect if a partial reload is in progress in the script using IsPartialreload().

For example I use section access to control access to the document and when I want to update it I really dont want to have to reload the data as well.

I achieve this using REPLACE and ADD (note that I also have a hard-coded back door in case of a problem with the access control spreadsheet!):

SECTION Access;

[Access Control]:
// The access control spreadsheet is secured and is easier to maintain than an inline table.
// Note that * in other than system fields has no real meaning as 'all'.
REPLACE LOAD SERIAL,
NTNAME,
NTDOMAINSID,
USERID,
PASSWORD,
ACCESS
FROM $(vRelPath)Access.xls (biff, embedded labels, table is [$(vDocumentName)$]);

// Ensure Administrator access is always possible in case of a problem with the access control spreadsheet
ADD LOAD * INLINE [
SERIAL, NTNAME, NTDOMAINSID, USERID, PASSWORD, ACCESS
*, *, *, XXXXX, XXXXXXXX, ADMIN
];

SECTION Application;

EXIT SCRIPT WHEN IsPartialReload();

// Position any SET/LET of variables here that should not be reset by partial reload

Regards,

Gordon

Partial Reload problem

Wed, 15 Feb 2012 13:52:45 GMT

Hi Rainer and jagan thnx for your ideas now i got some idea on Partial reload...

Regards,

Anil

Re: Partial Reload problem

IAMDV — Tue, 24 Apr 2012 05:50:57 GMT

Jagan/Anil,

I know this is old thread but we can still load only one table by using the "Add" prefix and followed by "Exit Script" keyword. If you add this script at the beginning of your document script then you can load only one table while not touching the rest of the tables. Ofcourse, you need to run Partial Reload instead of normal/full reload. I would recommend using "Only" qualifier to make sure this piece of script is disregarded during normal reload.

I hope this makes sense.

Good luck!

Cheers - DV

www.QlikShare.com

Re: Partial Reload problem

Anonymous — Wed, 26 Sep 2012 14:33:07 GMT

Hello, I try to update the Section Access whit partial reload. The command "replace" doesn't work.

It works perfectly if script runs normally. We use QV 11.

Section Access;

Replace LOAD
UPPER(ACCESS) as ACCESS,
UPPER(NTNAME) as NTNAME,
TEXT("FIELD") as FIELD;
SQL SELECT *
FROM ODBC.dbo."RIGHTS";

Section Application;

Re: Partial Reload problem

Fri, 09 Nov 2012 16:55:32 GMT

Hello,

same problem here. I only get weird errors.

Anyone know a answer to this problem?

Re: Partial Reload problem

IAMDV — Sat, 10 Nov 2012 10:59:54 GMT

Don't think you can use Partial Reload in the Section Access Script. I might be wrong but I'm guessing this... I don't see any documentation but you can't use Partial Reload between Section Access and Section Application. Instead why don't have you a QVD builder which generates the Section Access script and you can use partial reload in the QVD builder which does the job.

Cheers,

www.QlikShare.com

Re: Partial Reload problem

Anonymous — Mon, 12 Nov 2012 08:26:13 GMT

I get a replay from QlikView consulting. It is not possible to load Section Access partiell. We make it in two steps now: first step - load data mart to qvw and second step: import data mart with binary command and in addition load secction access part to second qvw file.

Re: Partial Reload problem

Mon, 12 Nov 2012 09:55:23 GMT

I thought of this option as an alternative.

But now i have prove so thx for the answere.

cheers,

Markus 😃