topic Re: date condition in script in QlikView

date condition in script

upaliwije — Sat, 02 Aug 2014 18:32:58 GMT

Hi Friends

LOAD

DATE(POL_PERIOD_FROM) AS POL_PERIOD_FROM ,

DATE(POL_PERIOD_TO) AS POL_PERIOD_TO ,

INT_MODE,

INT_CLASS_CODE,

AMOUNT

FROM

SS_Claim.qvd

(qvd)

WHERE POL_PERIOD_TO BETWEEN '01-JAN-2014' AND '30-JUN-2014';

in my above script the condition highlighted in red does not work. What may be the correct script. Pls help me

Re: date condition in script

Anonymous — Sat, 02 Aug 2014 19:02:16 GMT

I do not believe that BETWEEN is a valid QlikView function.

Try using a greater than and a less than for the condition.

Re: date condition in script

its_anandrjs — Sat, 02 Aug 2014 19:39:56 GMT

Hi Upali

Bill is right you have to use Greater than or Less than operators with the date fields for solution please see the load script with below load script.

LOAD

DATE(POL_PERIOD_FROM) AS POL_PERIOD_FROM ,

DATE(POL_PERIOD_TO) AS POL_PERIOD_TO ,

INT_MODE,

INT_CLASS_CODE,

AMOUNT

FROM

SS_Claim.qvd

(qvd)

Where POL_PERIOD_TO >= '01-JAN-2014' and POL_PERIOD_TO <= '30-JUN-2014';

Re: date condition in script

upaliwije — Sun, 03 Aug 2014 09:22:48 GMT

Thanks both of you