Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulgoyal1287
Contributor III
Contributor III

Qlik Sense: Read External Trigger Text file to refresh a QVD in every 10 Minutes

Greetings Community Members,

We need your help in suggesting the way out to the following problem statement:

In our DW, few tables get refreshed in every 10 minutes & a text file is generated on a location confirming the completion time in every 10 minutes.

we want to develop a solution in Qliksense which will read the creation time of above text file & it is within 10 minutes cycle it will refresh the QVD.

Just in case if text file is created after 5 minutes of 10 minutes cycle it will skip the current cycle & wait for next cycle.

To Demonstrate an example:

Let's say a new cycle starts at 'DD/MM/YYYY HH:10:00'

Text file is available at 'DD/MM/YYYY HH:10:40'.. it should check if it is under current cycle.. if qualifies.. refresh the QVD

If text file is available at 'DD/MM/YYYY HH:16:00' (after 5 minutes of start of current cycle) it should skip the refresh & wait for next cycle & text file update.

It would be really helpful for me if there is any suggestion available. Thank you in anticipation.

Best Regards,

Rahul

1 Reply
Gysbert_Wassenaar

Perhaps something like this:

tmpTime:

LOAD If(Mod(Minute(TimeStamp#(@1,'DD/MM/YYYY hh:mm:ss')),10)<5,1,0) as DoReload FROM textfile (txt)

LET vDoReload  = peek('DoReload');

If vDoReload = 0 Then

     exit script

End if


talk is cheap, supply exceeds demand