Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rahulgoyal1287
New 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

Tags (2)
1 Reply
MVP & Luminary
MVP & Luminary

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

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