topic Re: Writing back to a QVD in QlikView

Writing back to a QVD

sarathi_pm — Wed, 25 Nov 2020 16:16:04 GMT

Hello Guys,

I am working on a Qlikview App where the input files are Excel Timesheets.

There is a Qlikview Script that loads the Data from Multiple Excel files and creates a Master QVD.

The Timesheet Reconciliation file, takes the data from the Master QVD and shows the Variance Report that is consumed by the users.

Question:

Is there a way to write back to the QVD (only the edited records), if the users wants to change the hours in the Qlikview Application? So that the Master QVD is updated with the users data?

Thanks

Sarathi

Re: Writing back to a QVD

Anil_Babu_Samineni — Mon, 04 Dec 2017 12:09:43 GMT

Normally, Qlik works like below

Load * From Table;

Store Table into FilePath.qvd;

Load * From QVD;

So, In future if you edit anything from excel as our inputs it can store and effect to QVD directly. If needed you can work and create QVD generator with some Task Schedule allocation

Re: Writing back to a QVD

sarathi_pm — Mon, 04 Dec 2017 12:16:22 GMT

Hi Anil,

Thanks for the Response.

In this case, the user doesnt wants to go back to excel to update. Is there a way for the user to update the record in the qlikview straight table which will update the record in QVD?

Re: Writing back to a QVD

Anil_Babu_Samineni — Mon, 04 Dec 2017 12:56:58 GMT

Let's consider as example

Sample:

LOAD * Inline [

Name, Sales

A, 100

B, 200

C, 300

];

If we store this in to QVDalways input data stored in XML format

So, then after that if we update C from 300 - 400. Where QVD needs to store as 400. What USER needs o done here with that?

Re: Writing back to a QVD

Peter_Cammaert — Mon, 04 Dec 2017 13:03:48 GMT

You could try by adding INPUTFIELDs to your straight table, and letting the user save the result to QVD. Upon the next reload, that update QVD may be pulled in by your load script and override the data from the master file. You could even write back this updated table to the Master Data QVD, but that will be tricky (multiple simultaneous reloads? What happens in the AccessPoint where you can't save to the server. Except via shared folders)

It won't be simple... But then QlikView is a BI Analysis tool, not a QVD editor.