Hi,
can anyone please share some script by which will check the latest date from backend table - and depending upon that how you’re holding or triggering the qlik app reload?
cause I am facing a serious problem , where on some days backend table procedure is still overrunning & our qlik app is getting reloaded in between that , as per schedule - and sometimes due to this refresh timings syncing issue dashboard is populating null records - so how can we avoid it ?
my date field is “update_date”.
example : if update_date <= timestamp#(today()) then hold else reload - but how we can write it , whether we should use loop or what exactly?
I am not going to put my app in sleep because there is no guaranty after keeping app in sleep for 2hours also our backend table refresh will be completed. So looking for some alternative scripting option.
Any help would be appreciated.
Chalorme Roy Mukherjee