topic Timer in QlikView in QlikView

Timer in QlikView

markgraham123 — Thu, 18 Feb 2016 21:00:24 GMT

Hi All,

I'm using timer in the qlikview...

I just want to convey message to user at the particular time...

=If( (Time#(Now())>Time#('11:00:00', 'hh:mm:ss')) and (Time#(Now())<Time#('16:00:00', 'hh:mm:ss')) , 'Peak Time', Time#(Now()))

Somehow the above condition is not fetching the message.

Any help is highly appreciated!

Re: Timer in QlikView

sunny_talwar — Thu, 18 Feb 2016 21:07:37 GMT

Try this:

=If(Num(Frac(Now())) > Num(Time#('11', 'hh')) and Num(Frac(Now()))< Num(Time#('16', 'hh')), 'Peak Time', Time(Now()))

Re: Timer in QlikView

markgraham123 — Thu, 18 Feb 2016 21:14:59 GMT

Sunny,

Can i please know Num(Frac(Now())) functionality....

When i tried that function separately it's throwing decimal value.

Re: Timer in QlikView

sunny_talwar — Thu, 18 Feb 2016 21:19:17 GMT

Num() function include Date and Time and when you do a comparison just to the time you are basically comparing 42418.678.... to a very small decimal number 0.45833333 or 0.666667. By doing frac, I remove the 42418 part and do the comparison of just the time component:

0.678... > 0.45833333 and 0.678 < 0.666667

instead of

42418.678 > 0.4583333 and 42418.678 < 0.666667 which will always be false

Does that make sense?

Re: Timer in QlikView

markgraham123 — Thu, 18 Feb 2016 21:21:48 GMT

Got it!

Thanks a lot friend

Re: Timer in QlikView

sunny_talwar — Thu, 18 Feb 2016 21:26:53 GMT

No problem at all