topic Re: Partly load of data in QlikView

Partly load of data

sspe — Tue, 10 Dec 2013 09:33:35 GMT

Hi,

Is it some way possible to control which LOAD script are being run when doing a reload?

I have a document that loads data from approx. 15 different tables and write it down to 15 different QVDs. Sometime I'd like to only run one or two of the LOAD scripts to update only these couple of QVD but how can I "disable" the LOAD scripts I don't want to run?

I have one script/QVD per tab, so if I can disable the sepcific tabs is will also work for me.

Regards

Steen

Re: Partly load of data

Tue, 10 Dec 2013 09:35:51 GMT

Hi Steen

you can use a PARTIAL RELOAD

either with ADD LOAD which concatenates data

or REPLACE LOAD which loads from scratch

best regards

Chris

Re: Partly load of data

MayilVahanan — Tue, 10 Dec 2013 09:36:07 GMT

Try with exit script.

I think you are looking for tat;

Re: Partly load of data

sspe — Tue, 10 Dec 2013 09:53:55 GMT

Hi Christian,

Thanks for the input, but I'm not sure it's exactly what I'm looking for. I'd like to be able to control which tables are being loaded for e.g. testing purposes. If I e.g. do a load of customer, contacts, orders and Invoices in my document, I'd like to e.g. specifiy that now I only want to load/reload the customer part. Then the next time I'd maybe only want to run the Invoices part.

If I have to do it with parameters and/or variables it would be ok - I basically just want to be albe to decide which parts of my document I want to run instead of having to run it all.

Regards

Steen

Re: Partly load of data

sspe — Tue, 10 Dec 2013 09:54:50 GMT

Hi,

This might be an option, but do you have an example of how this should be done?

Regards

Steen

Re: Partly load of data

qlikpahadi07 — Tue, 10 Dec 2013 10:04:22 GMT

you can use IF else in Script and create a Flag in begining

Flag1 = 1

Flag2 = 1

Flag3 = 0

if Flag1 = 1

reload

else

.....

Re: Partly load of data

Tue, 10 Dec 2013 10:06:57 GMT

an easy solution is to set some flags like

LET DoClient = true();

LET DoProducts= false();

LET DoWhatYouWant = true().....

and for each part you do a test

IF DoClient THEN

END IF

SO you just have to modify your flag. You can even make it in a file poutside the script

best regards

Chris

Re: Partly load of data

jagan — Tue, 10 Dec 2013 10:31:56 GMT

Hi,

Move the Script tabs to the beginning which you want to execute and after that script just give this statement

EXIT SCRIPT;

Qlikview stops executing after this statement.

Example:

LOAD * from Table1;

LOAD * from Table2;

EXIT SCRIPT;

LOAD * from Table3;

When above script executes only Table1 and Table2 are reloaded after that execution stops.

Regards,

Jagan.

Re: Partly load of data

sspe — Tue, 10 Dec 2013 10:36:00 GMT

hmmm... I don't know why I didn't even tried this first..... I think I had the impression that this wouldn't work for a load script but it's actually something like this I was looking for.

Thanks for the help

Regards

Steen