Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Crash 😛
Nice one
Well, for one thing
: ABORT; :
works equally well, and is a bit less dramatic
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?
Please close the thread