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

MEJ — Wed, 25 Nov 2020 16:16:04 GMT

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

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

tresB — Tue, 02 Jul 2019 09:42:24 GMT

Current time : =Time(now())

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

muhammadushaque — Thu, 12 Mar 2020 14:28:13 GMT

Did You Done this task ? I also want this. Kindly help me.