topic Re: Reload only when QVD is updated with new data in App Development

Reload only when QVD is updated with new data

LorenaGSaar — Thu, 06 Jan 2022 09:10:51 GMT

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 😉

Re: Reload only when QVD is updated with new data

anat — Thu, 06 Jan 2022 09:27:20 GMT

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...

Re: Reload only when QVD is updated with new data

LorenaGSaar — Fri, 07 Jan 2022 08:45:46 GMT

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?

Re: Reload only when QVD is updated with new data

MindaugasBacius — Fri, 07 Jan 2022 09:12:02 GMT

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);

Re: Reload only when QVD is updated with new data

vikasmahajan — Fri, 07 Jan 2022 12:21:14 GMT

Hi,

Auto Reloading Qlik Sense Apps- Steps

ETL Can create a text file every data depending upon the frequency of reload as per business requirement.
Schedule task in qmc to check whether text file is available on share path
If file not exists then app will create a text file SALES_PERFORMANCE_2018_12_28.TXT
If file exists for current date then it will terminate the execution and task will get failed.
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