topic Set Old Data when Reload failed in QlikView

Set Old Data when Reload failed

Wed, 14 Dec 2011 11:26:01 GMT

Good Morning,

Is possible to set old data when Reload script failed?

I reload the Reports by Qlik Management Console and Set in the Reports Script 'Set ErrorMode=0'.

So, when a Script failed the report is updated but is empty while i should use the old data before the reolad.

Many Thanks and Best Regards.

Wed, 14 Dec 2011 11:36:22 GMT

hi,

You can do this by using Exit Script

ex if errormode=0 then

ExitScript;

thanks

Vivek

Wed, 14 Dec 2011 12:22:56 GMT

Many thanks for your help.

I tried like this:

Set ErrorMode=0;

Select FIELD1 from TableNameWorng;

if errormode=0 or ScriptErrorcount >0 then

ExitScript;

end if

but the result after the reloading is empty again 😞

flipside — Wed, 14 Dec 2011 12:54:13 GMT

Try STOREing the current data to QVDs and if there's an error reload them back in.

flipside

Thu, 15 Dec 2011 08:38:26 GMT

It's a good idea! many thanks!!

I have many report to converted and I hoped that there was a simple setting to write in the script.but I think your solution is the only possibility.

Many thanks and Best Regards