topic QVD Load in App Development

QVD Load

Anonymous — Sat, 18 Mar 2017 12:34:14 GMT

Hello Everyone

Please help me in the below query and let me know is it possible or not.

I have created two sections for dashboard in Qlik Sense:-

First create a data model in one app and store the data in qvd.
Secondly create a visualisation app where I am sourcing these qvd to create the dashboard

Thus if data model qvd fails due to any reason any day, my visualisation app will always shows the result as the visualisation is based on stored qvd's. I am using QMC for loading the data in QVD and visualization app.

Now the issue with that is if my qvd app fails on any day i.e. 3/17/2017. It means the stored qvd does not refreshed and contains the old data till 3/16/2017.

In visualisation app, because I am sourcing QVD and it is scheduled task by QMC it will execute successfully and shows "Data last Loaded" = 3/17/2017 which is not correct.

Is there any way to resolve the issue i.e. if my QVD app fails on any day, the visualisation app shows the "Data Last Loaded" till my QVD app last updated. Here as above it shows 3-16-2017

Thanks

Re: QVD Load

marcus_sommer — Sun, 19 Mar 2017 17:41:54 GMT

If your data contain a current date you could display this with something like: max({1} Date). Another approach would be to use filefunctions to read the filetime from your qvd, for example: filetime('Path/File.qvd').

- Marcus

Re: QVD Load

kaanerisen — Sun, 19 Mar 2017 18:36:24 GMT

Hi Deepanshu,

If your second app depends on the qvd file which is generated by the first app, how about to define a triggered task for your second app. So If your first app's task failed then your second app task won't run.

https://help.qlik.com/en-US/sense/3.2/Subsystems/ManagementConsole/Content/create-reload-tasks-from-tasks.htm