topic GoTo command in script in QlikView

GoTo command in script

Mon, 29 Nov 2010 07:38:46 GMT

Hi all,

Is there a way to to do a "GOTO" command in QlikView script? Currently I have a situation where I need to do some data checking before executing the load script. The sample scenerio:-

ExecDate=select top Date from ControlTable;

if not exists( select * from Data where Date=$(ExecDate)) then
goto Error;
else
LOAD * from Data2;
end if;

Error:
LET errormsg='No data for this date';

GoTo command in script

sunil2288 — Mon, 29 Nov 2010 07:54:14 GMT

You can try it through Macro statement.

Regards

Sunil kumar Panda

GoTo command in script

Thu, 02 Dec 2010 07:41:27 GMT

Hi Sunil,

Thanks for the suggestion. But do you have any other method? This is because macro might not work with Publisher.

GoTo command in script

Thu, 02 Dec 2010 08:33:27 GMT

I think, we don't have facility to transfer the control from one place to other place to execute the commands.

My suggesting is, you can try as below:

ExecDate=select top Date from ControlTable;

if exists( select * from Data where Date=$(ExecDate)) then

LOAD * from Data2;

Else

LET errormsg='No data for this date';

end if;

GoTo command in script

Tue, 21 Dec 2010 04:44:51 GMT

Thanks for the suggestion. I guess there is no other method other than using the else statement.