Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MEJ
Contributor III
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

2 Replies
tresesco
MVP
MVP

Current time : =Time(now())

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

muhammadushaque
Contributor II
Contributor II

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