topic Script Logic Help in QlikView

Script Logic Help

amit_saini — Mon, 27 Nov 2017 06:32:01 GMT

Hi Folks,

I'm using below logic to when I'm having condition based on "Hour".

IF(Hour(Date) < 8, Date-1,Date) as Date.tmp

Now what I want to do is to have condition based on "Minutes"

I need logic something like below:

IF(Minute(Date) < 08:45:00, Date-1,Date) as Date.tmp

Please help!

Regards,

Re: Script Logic Help

Anil_Babu_Samineni — Mon, 27 Nov 2017 06:50:06 GMT

Either you could need to elapse time to set as hour to exist like

IF(Minute(Date) < Interval(Interval#(08:45:00,'hh:mm:ss'), 'mm'), Date-1,Date) as Date.tmp

Re: Script Logic Help

amit_saini — Mon, 27 Nov 2017 07:26:25 GMT

Hi Anil,

Thanks for hint , but it's not giving me right output.

Regards,

Amit

Re: Script Logic Help

stabben23 — Mon, 27 Nov 2017 07:30:39 GMT

Hi,

I have solved the same problem With this script, maybe need some modification as I use timestampfield and also the other way around. My script is: if time is bigger or Equal than 06 use date else use date-1(yesterday)

if(time(frac(timestamp(Date,'hh:mm:ss')))>=time('06:00:00'),timestamp(Date),timestamp(timestamp(Date)-1)) as %Date,

Re: Script Logic Help

amit_saini — Mon, 27 Nov 2017 07:46:18 GMT

Yes this is working!

Thanks a ton