topic Re: time check in QlikView

time check

ali_hijazi — Mon, 28 Nov 2011 12:06:18 GMT

Hello

I got a qvw document on which I created a task for scheduling reload

how can I check if the script is running before or after 12:00AM after midnight?

there is a variable declared in the document whose value depends on whether the reload is carried on before midnight or after midnight

how can I make this time check?

please advise

time check

christophebrault — Mon, 28 Nov 2011 12:47:27 GMT

hi,

The function =Realoadtime() will give you the date and time for the last reload of your document.

time check

ali_hijazi — Mon, 28 Nov 2011 12:54:27 GMT

so?

time check

christophebrault — Mon, 28 Nov 2011 13:01:24 GMT

So compare the time obtained by Reloadtime() with 12:00:00 in your condition.

Perhaps i'm not understanding very well what you want to do...

Put an exemple of what you need ?

time check

ali_hijazi — Mon, 28 Nov 2011 13:25:51 GMT

okay

how to compare reloadtime() with 12:00AM

what is the function? is it reloadtime() - 12:00Am sure not

Re: time check

Miguel_Angel_Baeyens — Mon, 28 Nov 2011 13:31:36 GMT

Hi,

You can use the Interval() function and Time()

=Interval(Time('00:00') - Time(Frac(ReloadTime())))

That will return, for example, "-01:00:00" (hh:mm:ss) if ReloadTime() (when reload finished) is 1 AM.

Hope that helps.

Miguel

Re: time check

christophebrault — Mon, 28 Nov 2011 13:37:42 GMT

in your variable, try :

=if(time(reloadtime())>maketime(12,00,00),'your value','your other value')

With this expression, you can affect a different value to your variable depending on the time your document was reloaded, before or after 12:00.

Look the example

time check

Mon, 28 Nov 2011 13:53:14 GMT

maybe this:

= ' Last Reloaded on: ' & ReloadTime()

you can create a text object and add this to the "text"

time check

ali_hijazi — Mon, 28 Nov 2011 20:08:39 GMT

isn't there a method that returns a number upon comparison?

so that I check if the returned number is positive or negative?

Re: time check

Miguel_Angel_Baeyens — Mon, 28 Nov 2011 20:41:32 GMT

Hi,

Actually that's what Interval() does. You can use an If() conditional to check whether it is positive or negative.

Regards.

Miguel