topic Re: Reload status in QlikView

Reload status

lylererger — Tue, 03 Sep 2013 07:06:44 GMT

Hi. I'm trying to get reload status in script. For instanse, if I reload onse the document, for the second time i want to get that reload status for my script efficiency.

For example, in case of the first reload I address to tables, I getting their properties, number record, number of fields, a field with date, minimum and maximum. But in case of the following reload I it shouldn't do.

Thnx. OM.

Re: Reload status

tresB — Tue, 03 Sep 2013 07:09:03 GMT

May be you need to read the log file using the script. Before that you must enable the log file generation.

Re: Reload status

lylererger — Tue, 03 Sep 2013 07:16:20 GMT

I created a variable at the end of a script

LET vReload = 1;

Also I want to create a condition if vReload <>1, then read this piece of a script, else - not to read.

But a problem that it in case of each reload will accept NULL status, and it is necessary for me 1. How it can be done?

Re: Reload status

dmohanty — Tue, 03 Sep 2013 07:17:06 GMT

Go to Document Properties>>General Tab>>Enable the Generate Log File.

Every time the QVW is reloaded Log file will generated and you can see the status, error, lines fetched, time taken etc.

But in this case everytime you reload the QVW, Log File will be overwritten. YOu can't see the old Log File.

If you need multiple versions of Log File , after enabling Generate Log File, enable the Timestamp in LOg File.

This will create Log file with timestamps.

Regard!!!

Re: Reload status

tresB — Tue, 03 Sep 2013 07:29:45 GMT

May be something like this?

If ReloadTime()= null() Then // this checks if this is the first time reload or not
let vVar=0;
Else
vVar=10;
End if

TRACE $(vVar); SLEEP 1000; // merely to check if it works

Now you can check the variable and put your conditional script under that.