topic How do you handle reloads that return no results in QlikView

How do you handle reloads that return no results

paputzback — Mon, 26 Jan 2026 18:19:17 GMT

We have an app that once in a blue moon one of the scripts doesn't return data. If we re run the app it loads fine. Now I know there is more research to be done on finding out why that is happening. But for right now, I am being told to come up with a solution to notify someone if a table comes back with zero records. FYI, I am the server admin, not the developer. But in my limited knowledge of the application, I would think there would be a way to fail the reload if a script returns zero rows or less than a certain parameter, or have the script email the admins if it returns zero rows. And maybe it could even reschedule itself to run 10 minutes later.

Thanks,

Phil

Re: How do you handle reloads that return no results

petter — Fri, 05 Feb 2016 18:12:29 GMT

You can use the function NoOfRows ('tablename')

and check for 0.

Re: How do you handle reloads that return no results

Gysbert_Wassenaar — Fri, 05 Feb 2016 18:13:09 GMT

Perhaps this video from QlikCentral helps:

Re: How do you handle reloads that return no results

petter — Fri, 05 Feb 2016 18:18:17 GMT

For example like this:

Customers:

LOAD

SQL

SELECT

FROM

Customers;

Exit Script When NoOfRows('Customers') = 0;

Re: How do you handle reloads that return no results

paputzback — Fri, 05 Feb 2016 18:20:17 GMT

So a force exit of the script throws an error?

Re: How do you handle reloads that return no results

petter — Fri, 05 Feb 2016 18:28:06 GMT

To also have a wait and retry:

Retries = 0;
DO
    Retries = Retries + 1;
    Customers:
    LOAD
      .....;
    WHEN NoOfRows('Customers') = 0 AND Retries < 5 SLEEP 600000;    // Wait 10 minutes before next retry
LOOP UNTIL Retries = 5 OR NoOfRows('Customers') > 0
EXIT SCRIPT WHEN NoOfRows('Customers') = 0;

Re: How do you handle reloads that return no results

petter — Fri, 05 Feb 2016 18:52:05 GMT

No it doesn't ... there is no statement to throw an error really... maybe simulating it by doing something that throws an error - a bit ugly but it works...

Re: How do you handle reloads that return no results

Hemantx — Thu, 08 Apr 2021 10:37:24 GMT

this doesn't work right? The sleep is highlighted in red