topic Re: Compare dates and exit script in QlikView

Compare dates and exit script

Tue, 13 Aug 2013 09:23:02 GMT

Good day,

I need to add a piece in my script that will compare a date
in my txt file (see below) and if today's date is bigger than that date
Qlikview must "exit script"

LOAD Transaction
FROM

Desktop\Sales\Info

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

the result from this load will be 2013\08\10, so if today's date is bigger, the script must exit

Please help

Thanks a lot

Re: Compare dates and exit script

er_mohit — Tue, 13 Aug 2013 09:26:02 GMT

LOAD Transaction
FROM

Desktop\Sales\Info

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)where Transaction<=Today();

Re: Compare dates and exit script

MayilVahanan — Tue, 13 Aug 2013 09:26:50 GMT

Try like this

Load

Transaction
FROM
Desktop\Sales\Info
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq) where Transaction <= Date(Today(),'YYYY\MM\DD');

Re: Compare dates and exit script

Tue, 13 Aug 2013 09:28:01 GMT

Chick this out:

// Make a table just for calcultating the variable:

Check:

NoConcatenate LOAD

Transaction

Resident YourTable

Order By transaction desc;

//Calculate the variable:

LET varCheck = Peek('Transaction',0);

//We don't need the tble anymore:

DROP Table Check;

IF ($(varCheck)>&(Today())) then

TRACE Exiting...;

Exit Script;

ENDIF

Re: Compare dates and exit script

tresB — Tue, 13 Aug 2013 09:31:14 GMT

try like this:

Load Max(Transaction) as MaxDate

From ......;

Let vDate= Peek('MaxDate');

If( Date(today())>Date($(vDate)) ) Then

Exit Script;

Else

....;

Re: Compare dates and exit script

Thu, 15 Aug 2013 05:56:30 GMT

Thanks a lot, it worked.

Why did this not work though?

Date:

LOAD date(Transaction) as Transaction
FROM
Info (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

CheckDate:
LOAD Transaction
Resident Date;

LET CheckDate = Peek('Transaction',0);
LET CheckToday = Today();

DROP Table CheckDate;

IF ($(CheckDate)<=$(CheckToday)) then
Exit Script;

ENDIF