Hello All,
The below code successfully displays and counts down if i view in the Qlikview client on my laptop or on the either our publisher server or web server, however if I view the same document on our access point the countdown doesn't on it's own. If I click on the text boxes that contains the code it will refresh, but what I'm looking for is the ability to automatically refresh without user intervention, such that users can simply view the document including it's active countdown timer.
=Interval((if(hour(now())>'18',(Timestamp((date(now()+1)&' 19:00:00'),'DD/MM/YYYY hh:mm:ss')),(Timestamp((date(now())&' 19:00:00'),'DD/MM/YYYY hh:mm:ss'))))-(timestamp(date(now()))),'hh:mm:ss')
If there is any help you can provide that would be great, as I have struggled to find anything so far that would resolve this issue.
Many thanks,
Rob
