topic Re: Reload should fail if QVD size is zero in QlikView

Reload should fail if QVD size is zero

mohan2391 — Sat, 16 Nov 2024 05:12:40 GMT

Hi,

I have a requirement where the reload of QVW should stop when the size of QVD which I am loading in the QVW is zero.

How to achieve this ?

Thanks in advance

Re: Reload should fail if QVD size is zero

vvvvvvizard — Mon, 19 Nov 2018 06:58:49 GMT

if QvdNoOfRecords('Qvd name')<=0
EXIT SCRIPT
ELSEIF store qvd into path.qvd(qvd);
ENDIF

Re: Reload should fail if QVD size is zero

shiveshsingh — Mon, 19 Nov 2018 07:41:52 GMT

Before loading statement, you need to put below condition to check..

IF (qvdNoOfRecords('$(Path)') <= 0) THEN

Re: Reload should fail if QVD size is zero

Peter_Cammaert — Mon, 19 Nov 2018 08:01:50 GMT

As a second method, you can leave the LOAD logcic unchanged and add a test after the LOAD statement has been executed. Although the overhead of loading the XML header twice is not that large, you skip at least one of them. E.g.

TableSomething:
LOAD * FROM SomeFile (SomeOptions);

IF NoOfRows('TableSomething') = 0 THEN
  EXIT SCRIPT;
END IF

Re: Reload should fail if QVD size is zero

mohan2391 — Mon, 19 Nov 2018 08:18:34 GMT

Hi,

Thanks for your quick reply.

I forgot to mention 1 point, so please let me know if this code satisfies that or no.

Missed Point: I have 2nd QVW which runs after successful run of 1st QVW(here in 1st qvw, we are writing that above code) one.

So my requirement is that the 2nd QVW also should not run if the QVD size is zero along with the failure of 1st QVW.

So the code which you suggested can work for my other requirement as well ?

Re: Reload should fail if QVD size is zero

mohan2391 — Mon, 19 Nov 2018 08:20:17 GMT

Thanks for your reply, same question to you as well.

I forgot to mention 1 point, so please let me know if this code satisfies that or no.

Missed Point: I have 2nd QVW which runs after successful run of 1st QVW(here in 1st qvw, we are writing that above code) one.

So my requirement is that the 2nd QVW also should not run if the QVD size is zero along with the failure of 1st QVW.

So the code which you suggested can work for my other requirement as well ?

Re: Reload should fail if QVD size is zero

shiveshsingh — Mon, 19 Nov 2018 08:21:00 GMT

If your code will exit after checking first qvd then it'll not go to script further.

Re: Reload should fail if QVD size is zero

mohan2391 — Mon, 19 Nov 2018 08:26:05 GMT

it will not go to the further script in the SAME qvw (that means in 1st QVW)

But my question is, I have 2 QVWs. In QMC, there are 2 tasks created on these and there is task dependency created between them so that 2nd QVW will start run once 1st qvw runs successfully.

In the 1st QVW, I want to check QVD size is zero or not. If it is zero it should stop immediately AS WELL AS it SHOULD NOT allow 2nd QVW to run. So the 2nd QVW will run or no if I use your code and the QVD size is zero ?

Re: Reload should fail if QVD size is zero

Joost_d — Mon, 19 Nov 2018 08:32:53 GMT

DataFromQvd1:
Load 
  * 
from Qvw1;
//If you have publisher, use variable below in QMC
Let vNoOfRecords =NoOfRecords() ;

Store DataFromQvd1 into DataFromQvd1.qvd (qvd);

//running second Qvw conditionally
Let NoOfQvd1Records= QvdNoOfRecords(DataFromQvd1);

If $(NoOfQvd1Records) >0 then
     //Run Second Qvw
     DataFromQvd2: 
     Load * from Qvw2;
     Store DataFromQvd2 into DataFromQvd2.qvd (qvd);
Else
    //Exit Script               
Endif

Re: Reload should fail if QVD size is zero

mohan2391 — Mon, 19 Nov 2018 08:32:06 GMT

I am using binary load of 1st qvw in 2nd qvw

Re: Reload should fail if QVD size is zero

Peter_Cammaert — Mon, 19 Nov 2018 08:38:14 GMT

If you want a task furter up in the QMC chain to not run when a QVD is found to be empty, let your script crash if you detect no loaded rows. I often use a self-invented statement called CRASH; to do this , because QlikView doesn't supply something similar. Your script then becomes

TableSomething:
LOAD * FROM SomeFile (SomeOptions);

IF NoOfRows('TableSomething') = 0 THEN
  CRASH;
END IF

Of course, the task will fail and you will get an appropriate email scream from the QDS. But the second task will not run.

Re: Reload should fail if QVD size is zero

shiveshsingh — Mon, 19 Nov 2018 08:43:49 GMT

Crash 😛

Nice one

Re: Reload should fail if QVD size is zero

Peter_Cammaert — Mon, 19 Nov 2018 10:56:53 GMT

Well, for one thing

:
ABORT;
:

works equally well, and is a bit less dramatic

Re: Reload should fail if QVD size is zero

qlikwiz123 — Mon, 19 Nov 2018 17:28:19 GMT

If two QVW reloads are dependent, then QVW2 runs after 'Successful' execution of QVW1 in QMC. If QVW1 fails, then QVW2 would never reload at all. Isn't this the case in your tasks set in QMC?

Re: Reload should fail if QVD size is zero

qlikwiz123 — Mon, 19 Nov 2018 17:29:34 GMT

If two QVW reloads are dependent, then QVW2 runs after 'Successful' execution of QVW1 in QMC. If QVW1 fails, then QVW2 would never reload at all. Isn't this the case in your tasks set in QMC?

Re: Reload should fail if QVD size is zero

mohan2391 — Mon, 19 Nov 2018 18:07:31 GMT

Yes, it works in that manner only.
But in my case QVW1 was not failing, right..

So I have made that answer as correct.. That script looks for size of the qvd 1st, if it is zero it will fail because of writing CRASH/ABORT.. if it is not zero, normal execution will happen..

Re: Reload should fail if QVD size is zero

shiveshsingh — Tue, 20 Nov 2018 05:10:54 GMT

Please close the thread

Re: Reload should fail if QVD size is zero

mohan2391 — Tue, 20 Nov 2018 06:38:04 GMT

How ?