topic Intraday - 1 hour in QlikView

Intraday - 1 hour

n1ef5ng1 — Mon, 16 Jan 2017 02:52:52 GMT

Hi i have a report where it will execute loading of data @ 1015am. i would want the script to load everything except the current hour of the loading time as it is not a complete set of data.

FROM

[$(vLoad)Data\Intraday\Data.qvd]

(qvd)

WHEREDate=(FileTime() - MakeTime(1));

Something along this line but it doesnt work

Re: Intraday - 1 hour

girirajsinh — Mon, 16 Jan 2017 04:50:52 GMT

WHEREDate <= Timestamp(LocalTime()-MakeTime(1) )

WHEREDate <= Timestamp(Now()-MakeTime(1) )

Re: Intraday - 1 hour

rahulpawarb — Mon, 16 Jan 2017 10:08:22 GMT

Hello Ben,

If the Data.qvd file contains the Date and Time components then use below predicate logic in filter condition:

WHERE Date <= Today() & ' ' & MakeTime(Hour(Now())-1,Minute(Now()), Second(Now()))

Hope this will help.

P.S.: This is verify basic logic you can make use Date and Time functions to fine tune it.

Regards!

Rahul