Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

MEJ
New Contributor III

How to calculate a fixed hour minus a time variable? (Countdown)

Hi,

I was planning to have a countdown timer that tells when the Qlikview application will next be updated with new data.

I have the following script below that shows the current time. Also have minutes and seconds. 

=date(now(), 'hh')

=date(now(), 'mm')

=date(now(), 'ss')

First of all, I wonder if there is a script that shows the current time (clock) with hh:mm:ss. 

Second I would like to have a running countdown timer that tells me how much time there is left until Qlikview will be reloaded.

Something like this:

=12:00:00 - date(now(),'hh:mm:ss') and the result should be 01:54:32 for example if the current time is 10:05:28 (think I counted correctly)

Thanks

1 Reply
MVP
MVP

Re: How to calculate a fixed hour minus a time variable? (Countdown)

Current time : =Time(now())

Time1 - Time2 : =Interval(Time1-Time2, 'hh:mm:ss')