topic Re: How to Fix this issue in QlikView

How to Fix this issue

Mon, 19 May 2014 16:05:27 GMT

Let vExecuteWeeklyFlag=WeekDay(today()) <> 'Sun' and ( Hour(now(1)) <> 18 or Hour(now(1)) <> 19 or Hour(now(1) <> 20 ));

Let vExecuteMonthlyFlag=Day(today()) <> 1 and ( Hour(now(1)) <> 7 or Hour(now(1)) <> 8 or Hour(now(1) <> 9));

Let vExitMessage = 'This code should execute only on Sunday and hour is 7 PM or 8 PM or 9 PM. Or MOnth start between 7-9 PM. Current time is $(vUTC).Hence exiting script without taking a snapshot';

According to this the qvw has to run only on Sunday in between 7 PM or 8 pm or 9 pm. otherwise it has to show the exit message.

but when i am running this qvw its running other than specified time in Sunday.SO how to fix this issue.

If($(vExecuteWeeklyFlag)) and ($(vExecuteMonthlyFlag)) then

trace $(vExitMessage);

exit script;

Endif;

Re: How to Fix this issue

maxgro — Mon, 19 May 2014 17:21:06 GMT

perhaps because this is always true?

and ( Hour(now(1)) <> 18 or Hour(now(1)) <> 19 or Hour(now(1) <> 20 ))

Re: How to Fix this issue

Tue, 20 May 2014 05:37:54 GMT

Hi ,

Thanks for the reply ,

yes.. but how can we change this code so that it has to run only in between 6 to 8 pm onSunday?

Re: How to Fix this issue

Tue, 20 May 2014 07:37:14 GMT

Please reply somebody..

I need help immediately

Re: How to Fix this issue

maxgro — Tue, 20 May 2014 07:43:59 GMT

pseudo code

if (

(sunday and (17 or 18 or 19))

(startmonth and (7 or 8 or 9))

) then

else

exit

endif

Re: How to Fix this issue

Tue, 20 May 2014 07:44:53 GMT

Have you tryed to debug it?

Re: How to Fix this issue

tresB — Tue, 20 May 2014 07:54:00 GMT

For 6 to 8 pm:

Frac(Now())>=1/24*18 and Frac(Now())<=1/24*20

Re: How to Fix this issue

maxgro — Tue, 20 May 2014 08:16:29 GMT

try this

LET vGo =if(

// saturday at 17 18 19

(num(WeekDay(today()+0))=5 and ( match(Hour(now(1)), 17,18,19 )))

// 1st ofmonth at 7 8 9

(Day(today())=1and ( match(Hour(now(1)), 8,9,10 )) ),

1, 0

)

Re: How to Fix this issue

jonathandienst — Tue, 20 May 2014 08:31:22 GMT

So that would be:

Let vExecuteWeeklyFlag = WeekDay(today(1)) = 'Sun' And 18 <= Hour(Now(1)) And Hour(Now(1)) <= 20;

Let vExecuteMonthlyFlag = Day(today(1)) = 1 And 7 <= Hour(Now(1)) And Hour(Now(1)) <= 9;

If Not(vExecuteWeeklyFlag) And Not(vExecuteMonthlyFlag) Then

Trace $(vExitMessage);

Exit Script;

End If

I have taken the liberty of changing the sense of the flags to match the flag name (execute flag should be true() to execute).

HTH

Jonathan

Re: How to Fix this issue

Tue, 20 May 2014 10:37:20 GMT

But it has to run using UTC() time...

I tried with Tue as day and time as 6 to 8 pm ,,,its working ..if we change the hours other than that say 2 to 5 pm its also working....

but when we change the day as Mon and run within 6 to 8 pm its also running which is not correct...

Re: How to Fix this issue

Tue, 20 May 2014 10:50:49 GMT

you can try with below code:

WeekDay(Today()) ='Sun' and (Hour(now())=18 or Hour(now())=19 or Hour(now())=20)

in your check...

Re: How to Fix this issue

Tue, 20 May 2014 11:03:02 GMT

Its working for this timezone ..if we change the time other than this also its working..say time b.w 5 to 7 it should not work ..it has to show the message..but its loading ..how to solve this?

Re: How to Fix this issue

tresB — Tue, 20 May 2014 11:03:53 GMT

Your code is possibly failing because of improper use of 'OR' and 'AND'. It has to be something like:

(condition for weekday) AND (condition for hour)

Re: How to Fix this issue

Tue, 20 May 2014 11:08:02 GMT

as per the code which you have sent its working for within the time zone (6 to 8 pm) ragne whcih is correct..but if we change the time zone to other say 4 to 7 pm it still loading which is not correct..SO how to fix it?

Re: How to Fix this issue

maxgro — Tue, 20 May 2014 11:16:40 GMT

perhaps with?

LocalTime([timezone [, ignoreDST ]])

Returns a timestamp of the current time from the system clock for a specified time zone. The timezone is specified as a string containing any of the geographical places listed under Time Zone in the Windows Control Panel for Date and Time or as a string in the form 'GMT+hh:mm' or 'UTC+hh:mm'. If no timezone is specified the local time will be returned. If ignoreDST is -1 (true) daylight savings time will be ignored.

date(localtime('UTC') , 'hh:mm:ss')

localtime('UTC')

Re: How to Fix this issue

Tue, 20 May 2014 11:22:01 GMT

if(WeekDay(Today()) ='Sun' and (Hour(now())=18 or Hour(now())=19 or Hour(now())=20)) then

load * from temp;////Script...

else

message

endif;

Re: How to Fix this issue

Tue, 20 May 2014 11:24:44 GMT

I hope it should work with your server timezone, Check It. Hope it will give solution

Regards,

Chinni Kanna

Re: How to Fix this issue

Tue, 20 May 2014 11:37:11 GMT

Hi all ,

Thanks for the reply .. the actual problem is ..

I have a qvw which should run only on every Sunday at 6pm to 8 pm and monthly first day at 6 pm to 8 pm based on UTC time.

according to my code its running on sunday and month first day correclty at 6 to 8 pm...

but its also running the qvw on sunday other than 6 pm to 8 pm which is not correct... how to solve this issue?

the code is:

Let vExecuteWeeklyFlag=WeekDay(today()) <> 'Sun' and ( Hour(now(1)) <> 18 or Hour(now(1)) <> 19 or Hour(now(1) <> 20 ));

Let vExecuteMonthlyFlag=Day(today()) <> 1 and ( Hour(now(1)) <> 7 or Hour(now(1)) <> 8 or Hour(now(1) <> 9));

Let vExitMessage = 'This code should execute only on Sunday and hour is 7 PM or 8 PM or 9 PM. Or MOnth start between 7-9 PM. Current time is $(vUTC).Hence exiting script without taking a snapshot';

If($(vExecuteWeeklyFlag)) and ($(vExecuteMonthlyFlag)) then

trace $(vExitMessage);

exit script;

Endif;