topic Where statement in script for exact days in QlikView

Where statement in script for exact days

stjernvd — Mon, 23 Nov 2015 12:56:14 GMT

Hi,

In my script I need a where statement where my date is only chosen if the day ('DD') is either 28, 29, 30, or 31.

My date format is DD MM YYYY.

How would I write that in a where statement in the script?

sunny_talwar — Mon, 23 Nov 2015 12:58:58 GMT

May be this:

Where Match(Day(Date#(tradedate, 'DD MM YYYY')), 28, 29, 30, 31);

Where Match(Left(tradedate, 2), 28, 29, 30, 31);

Peter_Cammaert — Mon, 23 Nov 2015 12:59:40 GMT

WHERE Match(Day(date#(tradedate, 'DD MM YYYY')), 28, 29, 30, 31);

or even better

WHERE Day(date#(tradedate, 'DD MM YYYY')) >= 28;

[Edit] OK, took care of the non-standard format. If your DATEFORMAT string is 'DD MM YYYY' you can omit the date#() calls

Anonymous — Mon, 23 Nov 2015 13:02:46 GMT

Hello Stjernvd,

use the following where clause:

where Day(trade_date) = 28

or Day(trade_date) = 29

or Day(trade_date) = 30

or Day(trade_date) = 31;

tamilarasu — Mon, 23 Nov 2015 13:12:18 GMT

Just modified Sunny's solution.

SET vDate = '28','29','30','31':

Test:

LOAD *

From

Your Path.. where Match(Day(Date#(tradedate,'DD MM YYYY')), $(vDate));

Mark_Little — Mon, 23 Nov 2015 15:18:49 GMT

Hi,

Sunny's approach will give you the right answer.

Mark