Reload only when QVD is updated with new data

[LorenaGSaar]

Hello Community!

I have one question, it is silly but I don't know how to solve it.

Basically I have one app, which consumes some QVDs that is updated with new data only once per month (The update varies each month). So it's not smart to have a trigger to reload every day if new data is available only once per month, also is not possible to have a trigger in a specific day, because we don't know exactly when the qvds are refreshed.

But I want to automate it anyway, because we have plenty apps like this, and reload manually every month is not smart neither. 

Does anyone knows the best way I can achieve this scenario? I have created a internal script to check the date from fact, if it's equal with today(), if yes it reloads, if not exit script;
But the problem is when the condition is false, I don't load anything and my dashboard remains empty.

Thank you everyone for any suggestion 😉

[anat]

https://community.qlik.com/t5/Knowledge/Conditional-relaod-based-on-QVD-update-time/ta-p/1764531

can u try above link,may be u will get some idea...

[LorenaGSaar]

Hello Anat, thank you for the link.

But in this case I would need to force an error when my condition is not true, in order to keep all data in my app? 

[MindaugasBacius]

Just write something like this:

IF Match(Today(), 10) and Date(FileTime('xyc.qvd')) < Today() THEN //if todays day is 10 and the xyz.qvd is not updated yet update the xyz.qvd and store it

ODBC CONNECT TO DATABASE;

Table:
SQL SELECT fields
FROM abc.dbo.sqltable
;
STORE Table into [xyz.qvd];

ENDIF

//after that just load the xyz.qvd. Old or new version 🙂

Table:
LOAD *
FROM
[xyz.qvd]
(qvd);

[vikasmahajan · Accepted solution]

Hi,

Auto Reloading Qlik Sense Apps- Steps

1. ETL Can create a text file every data depending upon the frequency of reload as per business requirement. 
2.  Schedule task in qmc to check whether text file is available on share path 
3.  If file not exists then app will create a text file  SALES_PERFORMANCE_2018_12_28.TXT 
4. If file exists for current date then it will terminate the execution and task will get failed.
5. After  completing step3 qmc will  check text file and will start qlik task trigger based on this task another task can be created using dependency in qlik. 

Hope this helps you . Sorry I don't have license now other wise i could able to post scripts as well for your reference.

Thanks

Vikas