Writing back to a QVD

[sarathi_pm]

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

[Anil_Babu_Samineni]

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

[sarathi_pm]

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?

[Anil_Babu_Samineni]

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?

[Peter_Cammaert]

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.