topic Re: Run script if condition met. in QlikView

Run script if condition met.

ivandrago — Tue, 14 Mar 2017 23:09:16 GMT

Hi,

I want to create a QVD if the current time is between the hours of 08:00 AM and 10:00 AM, if it does not meet this condition I want it to Exit the Script.

I've tried to do the following Script IF Statement but does not seem to work, any ideas?

LET vHour = Hour(Now());

If vHour >= 8 And vHour <= 10 Then

TableA:

LOAD *;

SQL

SELECT *

From TableA;

ELSE EXIT SCRIPT;

Thanks

Re: Run script if condition met.

vishsaggi — Tue, 14 Mar 2017 23:20:16 GMT

Try this?

SET vQVDPath = 'yourpathhere';

LET vHour = Hour(Now());

If ($(vHour) >= 6 And $(vHour) <= 10) Then

Your ODBC or OLEDB Connection string here;

TableA:

LOAD *;

SQL

SELECT *

From TableA;

Store TableA into $(vQVDPath)tableB.qvd(qvd);

ELSE

EXIT SCRIPT;

ENDIF;

Re: Run script if condition met.

ivandrago — Tue, 14 Mar 2017 23:27:38 GMT

Thanks Alot

Re: Run script if condition met.

minajalalian90 — Mon, 04 Apr 2022 06:15:35 GMT

Thanks For your answer. Very useful. 💮