topic Reload the query only if the first script executes successfully in QlikView

Reload the query only if the first script executes successfully

Tue, 11 Aug 2009 12:04:12 GMT

Hi,

Is there a way to reload data only when the first query succeeds. To be clear, Select count(*) from forec where desc='Final'. If the query returns '1', I need the other query which follows to execute. If the Query returns' 0', I need the reload to fail. The other queries are no way related to the above query. How to do that?

--Santhosh

Reload the query only if the first script executes successfully

Tue, 11 Aug 2009 14:19:39 GMT

Maybe something like this:

Table1:

load x ;

sql Select count(*) from forec where desc='Final';

if peek('x') = 1 then

table2:

load y;

sql select...

else

exit script;

end if;